Automating a scheduled task with Outlook

Not open for further replies.



I am wanting to automate Outlook with a mail merge process to emails, it should read from a database for salutation, email address, etc....and then automatically send the emails every evening at 9:00 pm. I'm looking for suggestions to getting started with the automatic process. My choices:

A) Do I create an email, save it in the drafts folder and then how do I schedule this to happen every day?

B) Create a scheduled task from within Windows - ??

C) I'm clueless, I thought I could code within a vba "startup" module, but this is needs to be an unattended task.

Any suggestions, links, or pointers to get me started would be appreciated.

I'm familiar with vba and mail merge in MS WORD, using either MS Word 2003/ 2007


Roady [MVP]

And it should send the same email everyday as well?
What are you trying to achieve by this?


The body of the message is the same, but everyday my data source records change, so although the body of the email is the same, the salutation, the email address, and other field variables changes - all based on my data source. My main problem is that I don't know how I can actually get the mail merge process started without a human going through the process. I was hoping a 'task scheduler' might help me with using a 'startup module' within Outlook??? Am I trying to accomplish something not possible with Outlook?


OKay....maybe this is where my confusion is. I have a completely separate program using vba mail merge with MS Word, but in this case I wanted to initiate a mail merge with Outlook. I assumed a mail merge with Outlook would use a draft stored somewhere in Outlook?? If Outlook mail merge uses MS WORD, then I understand that I don't need to try to program in Outlook, but instead program with VBA in MS WORD.....and then figure out how I can initiate an unattended task in MS WORD.

Roady [MVP]

Correct, there are some 3rd party add-ins though which can also schedule a merge, but I'm not sure if that also will work in your case where you actually merge a Word document and an Excel document and send it via Outlook. Most 3rd party add-ins merge with data from Outlook.

Anyway, it is worth having a look;
Not open for further replies.
Thread starter Similar threads Forum Replies Date
I Automating message move between folders Outlook VBA and Custom Forms 0
R Automating from excel into shared Calendars Using Outlook 1
C Automating subject line Using Outlook 1
L automating a BCC on every email Using Outlook 1
S Merging SharePoint and user calendars or automating meetings Using Outlook 7
S Merging SharePoint and user calendars or automating meetings Using Outlook 2
J Automating Shared Calendar appointment reminders Using Outlook 1
T Automating Exporting to pst file Outlook VBA and Custom Forms 3
N Automating Outlook 2007 problem with sending mail Outlook VBA and Custom Forms 1
J Automating Word from script Outlook VBA and Custom Forms 8
S Automating the selection of email accounts upon adding email addre Outlook VBA and Custom Forms 1
S Outlook 2007: automating form with macro Outlook VBA and Custom Forms 2
V Scheduled backup of imap account Using Outlook 7
T Scheduled footer change Using Outlook 2
M Outlook does not bold calendar dates when events are scheduled for those dates. Using Outlook 1
T Resource room not sending notfications when meetings are scheduled from Outlook Using Outlook 3
D Outlook 2010 won't perform Send/Receive on IMAP folders as scheduled Using Outlook 2
S Meetings Scheduled To A Resource Via Outlook 2007, Do Not Book Using Outlook 1
H Scheduled a meeting and the organizer go set to an invitee. Using Outlook 1
M WBADMIN Scheduled Backup for Exchange 2010 Fails with Event ID 544 Error Exchange Server Administration 5
C Scheduled meeting delivers an email instead of a meeting notice. Using Outlook 2
M Sending an email invite to a scheduled reoccurring series of meetings at once even though certain occurrences in the series have been modified. Using Outlook 1
S "You do not have permission to send to this recipient" when making changes to scheduled meetings Using Outlook 3
A Possible to Disable send receive at startup, but keep scheduled send receive active? Using Outlook 3
M Use New-MailboxExportRequest as a scheduled task Exchange Server Administration 5
F Email Classified as Spam After Scheduled Task Reboot Exchange Server Administration 1
M Running Outlook as Scheduled task Outlook VBA and Custom Forms 1
O Scheduled Task Fails running Code to send Outlook Mail from Excel. Outlook VBA and Custom Forms 9
C Scheduled Task Doesn't work with Outlook 2007 Outlook VBA and Custom Forms 1
S Scheduled backup for BCM Database Tool BCM (Business Contact Manager) 1
C How do you add an attendee to a already scheduled meeting? Using Outlook 3
E Can't accept or decline task (no button appears) Using Outlook 4
B VBA to convert email to task, insert text of email in task notes, and attach copy of original email Outlook VBA and Custom Forms 4
B Task Filter Not Working When I add too many criteria Using Outlook 0
X If you change expiration date of repeated task it dupplicates Using Outlook 1
B How to show concatenated categories in list task view? Using Outlook 2
B VBA to Collapse Task Folder Groups Outlook VBA and Custom Forms 1
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
I Help with dates in task list. Using Outlook 5
Y Outlook Task View - Table Format - Customize Reminder Time to Drop-Down Selection Using Outlook 2
M Daily Task List Minimized Cannot Display Using Outlook 2
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
P Add a contact to the New Task in Outlook 2016 Using Outlook 2
S Codes for "Mark Complete" the task Outlook VBA and Custom Forms 2
W Deleting Sent Task Email, Deletes the task from my list Using Outlook 1
K Task priority modification Using Outlook 4
F Search folder for tasks in all task folders Using Outlook 1
JohnViuf Export task list view settings to other pc Outlook VBA and Custom Forms 16
V Changing default date for task follow-up buttons Using Outlook 2
K outlook workflow: automated task generation Outlook VBA and Custom Forms 4
Similar threads