Automatic delayed emails from Merge document

  • Thread starter Thread starter sbitaxi
  • Start date Start date
S

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
 
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
 
Back
Top