Thanks Ron

If however I wanted to send at a specified date and time, rather than x
mins after I actually run my code


Ron de Bruin wrote:

Hi Sean

This is working Ok on my machine

.DeferredDeliveryTime = DateAdd("n", 3, Now)

It wait for 3 minuts in the outbox before it go out


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
I test it this this evening Sean
First time for me also

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sean" wrote in message oups.com...
Thanks Ron

Not much look, wasn't sure of the syntax but I tried these two and both
shot the mail out straight off

.DeferredDeliveryTime = DateAdd("16:50", 1, Now)
.DeferredDeliveryTime = DateAdd("h", 1, "16:50")


Ron de Bruin wrote:
Hi Sean

You can try
.DeferredDeliveryTime

never us it but something like this
.DeferredDeliveryTime = DateAdd("h", 1, Now)


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sean" wrote in message oups.com...
I am using Ron De Bruin's excellent code to e-mail various files from
Excel, however is the feature available whereby I can specify within
the code a delayed time the mail should be sent at. Just like I can
specify the Importance, Read receipt etc

If I was to do this in outlook I'd choose Options - Do Not Deliver
Before etc. So I just wish to include this feature within the code by
specifying a date and Time. Thus I still run my Macro but my mail will
remain in Outlooks Outbox until the given time and date.

BTW, my date and Time would be values within a sheet, say Sheet2 A1


Thanks