VB Code to send Delayed Outlook Message

Question

Hello,

I am looking for the vb code to send an outlook message on a certain date.  I have the code working properly to send the message but can’t figure out how to delay delivery.

Here is the code I am using to create the email (as I said, it is working)

With OLMail

.to = EmailAddrs

.cc = “David Cornett”

.Subject = “Breakfast Club Reminder”

.Body = MsgText

.Send

End With

Note: OLMail, EmailAddrs, & MsgText are dimmed and defined earlier in the code.

Note 2: I have discovered that there is a .Delay property but apparently that only brings the message to the user’s screen and allows the user to review the message before he/she clicks the send button.

Note 3: I have also found something called Mail.DeferredDeliveryTime  but don’t know how to use it

Any help you can give me is ALWAYS greatly appreciated.

Thanks

David

Answer 1

From Ron de Bruin's site:

DeferredDeliveryTime'Stay in the outbox untill this date and time

.DeferredDeliveryTime = "1/6/2007 10:40:00 AM"

'Wait four hours

.DeferredDeliveryTime = DateAdd("h", 4, Now)

Answer 2

That appears to work. Sorry that it took so long to get back to this. Something more pressing came up.

Thanks for your help.