Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jet
 
Posts: n/a
Default Schedule An Email Merge

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.


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Schedule An Email Merge

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/...ttachments.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

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

"Jet" wrote in message
...
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.




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
selecting an email account for email merge? Terryl Mailmerge 1 February 1st 06 04:57 AM
Email merge not working TC Mailmerge 1 January 6th 06 06:48 AM
Email merge with Word 2002 RHS Mailmerge 2 April 15th 05 02:38 PM
email a mail merge Dan Mailmerge 2 March 10th 05 10:06 PM
Email Merge: Need to have URL show as active hyperlink Manash Mailmerge 1 December 22nd 04 12:51 AM


All times are GMT +1. The time now is 07:00 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"