John.McLaughlin
Board Regular
- Joined
- Jul 19, 2011
- Messages
- 169
Hello,
I send order confirmations via Excel and With Outmail. Currently I use this formula in cell B1 to delay the delivery until 9AM. It works fine if I am entering orders before 9AM.
=IF(NOW()>9/24,TODAY(),TODAY()+1).
Problem is, sometimes I am entering customer orders at night, and I want to hold the delivery until the next business day. Currently I have to change the delivery time by hand in Outlook, Options>Delay Delivery.
How can I change the formula to;
Thank you in advance!
John
I send order confirmations via Excel and With Outmail. Currently I use this formula in cell B1 to delay the delivery until 9AM. It works fine if I am entering orders before 9AM.
=IF(NOW()>9/24,TODAY(),TODAY()+1).
Problem is, sometimes I am entering customer orders at night, and I want to hold the delivery until the next business day. Currently I have to change the delivery time by hand in Outlook, Options>Delay Delivery.
How can I change the formula to;
- If between 9 to 5, send the mail,
- if before 9, hold until 9,
- if after 5, hold until the next day at 9am.
Thank you in advance!
John