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