Automatic delayed emails from Merge document

[sbitaxi]

I have a list of contacts that I want to send reminder emails to at
scheduled times as per event times drawing from a spreadsheet.

The following are fields in my spreadsheet.


Name
Email
Subject
Comment
Schedule date/time


How would I use the fields as source for my mail merge and the
schedule date/time to "delay" sending the email?


I haven't written a macro for a few years now and can't seem to
remember anything.


Any assistance is greatly appreciated.


Steven

 

[Sue Mosher [MVP-Outlook]]

Word's mail merge automation doesn't give you any access to the actual messages being sent. You'd have to write all the code in Outlook, rather than doing a mail merge. The basic method for creating a new message in Outlook VBA is Application.CreateItem. The sample at http://www.outlookcode.com/codedetail.aspx?id=788 shows basic techniques of working with Excel cells, working with Outlook item properties, etc. The object browser (F2 in VBA) will show you that the property for delaying a message is MailItem.DeferredDeliveryTime

If you need a few basics to start, see http://www.outlookcode.com/article.aspx?id=49

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers