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

Not open for further replies.

afshin r

Outlook version
Outlook 2010 32 bit
Email Account
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.
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.
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)
Thank you for your kind solution, I will check it and let you know.
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?
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 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.
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R Outlook 2021 Having problem setting up outlook 2021 with windows 11. I have 3 gmail accounts and I want the 3 gmail, emails to merge into the same outlook input. Using accounts in Outlook 0
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
V Setting up Outlook 2021 on new computer Using Outlook 2
AlphonseG Outlook 365 Outlook Crashes on setting SaveSentMessageFolder Outlook VBA and Custom Forms 4
e_a_g_l_e_p_i Outlook 2010 Help setting up Gmail account in Outlook 2010 Using Outlook 3
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 IMAP account Using Outlook 0
Diane Poremsky Setting the default Country for Outlook Contacts Using Outlook 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 Using Outlook 0
B Outlook Calendar/setting appointments Using Outlook 1
Diane Poremsky Adjusting Outlook's Zoom setting in Email Using Outlook 0
Diane Poremsky Setting Custom Reminder Times Using Outlook 0
A Can't stop from setting reminders on appointments? Using 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
K Setting Default Email Address for Meeting Replies Using Outlook 3
S Setting up Outlook 2010 to work with custom domain 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

Similar threads