Setting Emails to be send in calendar holidays to group of people

Status
Not open for further replies.

afshin r

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Is there a way (add in or something) to set up emails(Set up different types od emails) for different calendar Holidays, ceremonies and etc to be send to group of people filtered by country/region or category.

Thanks in anticipation for your time and effort.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange

afshin r

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Thank you for your prompt reply, actually I considered that but it just can handle one date for 1 person( if I'm wrong correct me please), for example: I want to send greeting cards at different occasion like xms, 4th of july, thanks giving it just can be presetted for 1 occasion.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
While it can handle one automatic date per person (two, if you use anniversary too), you can use either method with other dates. Using the birthday example, if you are creating a bunch of greetings for some holiday, replace this line: objMsg.DeferredDeliveryTime = bday with a hard date like this: objMsg.DeferredDeliveryTime = "#11/22/2012#" (that is for US thanksgiving)
 

afshin r

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Thank you for your kind solution, I will check it and let you know.
 

afshin r

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
Well, It's good for one or two anniversary

What I'm looking for, is something to handle more contacts.

If there was a possibility to select contacts through their category, it would be more better, because at the moment I have 250 contacts and over 150 ceremonies and anniversaries due to their region and country! Imagine how many macros should I write? after that by adding someone new I have to create macros for him either.

I think its more than a macro

Have you seen some sort of add-in for my request?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I don't have a macro and don't know of an addin but you have two options:

Mail merge. This is probably the best method to send greeting to a bunch of contacts for a specific holiday (Christmas etc). If you want to prepare it to send later, see Add attachments and set email fields during a mail merge to email - Slipstick Systems for a method to set any mail field on send. This will not use contact fields, like b-day.

You could use a For...next loop to pick up selected contacts. Basically write your own mail merge. I have a deadline to meet today - but when i get a chance, I'll look at this.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
O Setting default format for composing/replying to emails Using Outlook 3
B Problem when setting up 2010 from 2007, duplicating emails. Using Outlook 1
S Outlook 2003: Help with setting up a macro to reply to selected emails Using Outlook 2
J setting up outlook - cannot get my email account recognized-test emails appear in older outlook on a Using Outlook 2
J Outlook 2010- Emails deleted off POP server even though setting it set to leave them Using Outlook 6
P OWA Settings->Calendar->Events from Email; Setting changes do not hold Using Outlook 1
Marc2019 Setting up an Outlook Account on Mac Os 10.6.8 Outlook 2011 Using Outlook 1
L Outlook Office 365 client: won't remember my setting File, not to collapse ribbon Using Outlook 2
M Where is the setting to *turn off* open calendar in a new window? Using Outlook 3
llama_thumper Setting up forwarders on Exchange server Exchange Server Administration 0
B Setting rules Using Outlook 1
C iCloud Setting missing Outlook tab and Outlook missing the iCloud refresh button Using Outlook 4
B Setting defaults Using Outlook 2
C need help setting up outlook first time Using Outlook 1
P Reading Pane (Reading Pain?) Default Setting Using Outlook 1
W Setting up a custom form Outlook VBA and Custom Forms 2
mctabish Setting "Reply To" based on inbox Outlook VBA and Custom Forms 2
R Setting font and color used when replying to an email Outlook VBA and Custom Forms 3
M Setting flag follow up for next business day Outlook VBA and Custom Forms 1
Ed Sheehan Unusual behaviour in setting Sender (Outlook 2016) Outlook VBA and Custom Forms 4
Jennifer Murphy Equations don't comply with style setting to left justify Using Outlook 0
J Setting default address book Using Outlook 0
N Does a Shared Folder Policy override a Digital Signature Setting for macros? Outlook VBA and Custom Forms 6
Diane Poremsky Setting up an Outlook.com IMAP account New Slipstick.com Articles 0
Diane Poremsky Setting the default Country for Outlook Contacts New Slipstick.com Articles 0
H Need help setting up GetFolderPath-Makro with Vodafone IMAP Mail-Account Outlook VBA and Custom Forms 0
Diane Poremsky Adjusting Outlook's Zoom setting in Email New Slipstick.com Articles 0
B Outlook Calendar/setting appointments Using Outlook 1
Diane Poremsky Adjusting Outlook's Zoom setting in Email New Slipstick.com Articles 0
Diane Poremsky Setting Custom Reminder Times New Slipstick.com Articles 0
A Can't stop Outlook.com from setting reminders on appointments? Using Outlook.com accounts in Outlook 3
A Setting RULES with more than one condition in MS OUTLOOK Using Outlook 6
L Setting up my PA's Outlook Using Outlook 7
E Need Help on Setting up a repeated Reminder on Task with Reoccurence Every Year Using Outlook 6
N "Instant Search" setting a default view Using Outlook 3
H SETTING UP A "NEW" NEVER HAD NEVER USED EMAIL ACCOUNT Using Outlook 9
K Setting Default Email Address for Meeting Replies Using Outlook 3
S Setting up Outlook 2010 to work with custom domain outlook.com account BCM (Business Contact Manager) 3
D Setting defult "Show a room list" Using Outlook 0
Horsepower Setting appointments in calendar Using Outlook 3
J Setting tabs in contacts / notes field Using Outlook 0
T Setting a Default Subject from a certain Signature Using Outlook 0
K Help Needed - setting up Email in Outlook 2013 Using Outlook 3
mikecox setting Default area code in Contacts Using Outlook 5
G Outlook2013 - "From" name doesn't change even when changed in Account Setting Using Outlook 4
D How do I start completely from scratch in setting up Outlook 2013? Using Outlook 6
V View zoom setting changing Using Outlook 1
C Setting up Outlook 10 on Widows 8 using Google Server Using Outlook 3
I Outlook Appointments - Setting default text in message body Using Outlook 3
T Setting Color codes for each user of a shared Calendar Using Outlook 1
Similar threads


















































Top