Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2006

Tip: Looking for answers? Try searching our database.

Schedule An Email Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jet - 01 May 2006 14:51 GMT
Office 2003 - How do I schedule a mass email merge to be sent at a later
time?  I would like to schedule the mass emailing to be sent during non-peak
hours.


Doug Robbins - Word MVP - 01 May 2006 16:46 GMT
You will need to make use of the Outlook Object Model DeferredDeliveryTime
property in a visual basic macro to do this.

The procedure will be something similar to that used in the article "Mail
Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

I haven't tested this, but I think that the following modification (addition
of DeferredDeliveryTime = Now() + Format(1, "h")) to the routine in that
article would defer the sending of the emails by one hour.

   With oItem
       Set mysubject = Maillist.Tables(1).Cell(Counter, 2).Range
       mysubject.End = mysubject.End - 1
       .Subject = mysubject
       .Body = ActiveDocument.Content
       Set Datarange = Maillist.Tables(1).Cell(Counter, 1).Range
       Datarange.End = Datarange.End - 1
       .To = Datarange
       For i = 3 To Maillist.Tables(1).Columns.Count
           Set Datarange = Maillist.Tables(1).Cell(Counter, i).Range
           Datarange.End = Datarange.End - 1
           .Attachments.Add Trim(Datarange.Text), olByValue, 1
       Next i
       .Importance = olImportanceHigh
       .ReadReceiptRequested = True
       .Send
       .DeferredDeliveryTime = Now() + Format(1, "h")
   End With

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Office 2003 - How do I schedule a mass email merge to be sent at a later
> time?  I would like to schedule the mass emailing to be sent during
> non-peak
> hours.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.