Hi folks,
I am using
.DeferredDeliveryTime= "16:00"
to delay an email for 4pm to be sent the same day. Using the code I have there it sets the date in the Outlook delay to 30/12/1899 and sends the email straight away.
I need to be able to use todays date. I have tried
.DeferredDeliveryTime= "= TODAY()" & "16:00"
and various morphs of that with no joy. I have also tried using a variable by putting =TODAY() in a cell, setting the variable as this and using the variable as such:
DeferredDeliveryTime= Delaydate & "16:00"
Can anyone point me in the right direction?
Bookmarks