will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Delay Sending Outlook Messages
You hit Send, then realize you forgot the attachment. Or you misspelled the recipient’s name. Or you used Reply All, when you only wanted the message to go to one person. None of these things have ever happened to me (well hardly ever), but you might have been less fortunate.
All kinds of tragedies can strike in that ohnosecond, just after you fire off an email. As a bit of insurance, you can change a setting in Outlook, so messages are delayed a set number of minutes. Then, if you realize you didn’t want to include everyone in the lottery ticket email, you’ll have time to delete a name or two from the Send To list.
There are instructions for changing this setting on the Microsoft website. It will only take you a couple of minutes to make the change, and that investment will pay for itself the first time you can correct an error before an email is sent.
Update (2008-Sep-19): JP has written an article describing how to delay Outlook messages with programming.
September 18th, 2008 at 12:03 am
[...] Delay Sending Outlook Messages [...]
September 19th, 2008 at 3:56 pm
Hey Debra, you can also do this programmatically in Outlook. There is a DeferredDeliveryTime Property of the MailItem Object where you can set the delivery date/time. I’ll post some sample code on my blog.
–JP
September 19th, 2008 at 4:56 pm
[...] Delay Sending Outlook Messages, Debra Dalgleish writes about deferring delivery times for Outlook messages: You hit Send, then [...]
September 19th, 2008 at 9:40 pm
Thanks JP, I’ve updated the article to add a link to your blog.
September 21st, 2008 at 2:17 pm
Hi all
Yes I have this tip also on mt tips page of my Outlook examples, I think I never used it myself.
http://www.rondebruin.nl/mail/tips2.htm
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)
September 21st, 2008 at 8:00 pm
Thanks Ron! You have tons of good stuff on your site.
November 19th, 2008 at 10:41 pm
Ron de Bruin
‘Stay in the outbox untill this date and time
.DeferredDeliveryTime = “1/6/2007 10:40:00 AM”
I searched for hours for this solution…..You’re the man Ron.
In future when I Google VBA queries I will first try adding your name into the search criteria with what I need. I’ve seen a lot of your replies all over the place and I greatly appreciate your help to the internet community….
Cheers