So today I was approached by an internet friend of mine Richard Tubb, he had a bit of a challenge for me. As a keen Ms Outlook user, he wanted to see if there was a way of delaying all emails that he’d composed and hit send on during the weekend to arrive on the next working day.
Of course, Ms Outlook has the built in deferred delivery time function.. However, setting that manually each time could easily become a bind. So that’s where this little Outlook VBA Snippet steps it.
The code checks to see if today is a weekday upon sending the email, and if it is either a Saturday or Sunday, it then finds the date of the next Monday, and sets the deferred send option to that Monday at 7AM. Of course, should Richard be sending mail through the week, Outlook will simply ignore the code. Simple really
EDIT: So Richard came back to me with a second request, to delay mail sent on a weekday by 30 minutes, I have now adjusted the code to suit.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Dim nxtMonday As String Dim objMailItem As MailItem If Item.Class = olMailItem Then Set objMailItem = Item If Weekday(Date) = 7 Or Weekday(Date) = 1 Then nxtMonday = Date + (9 - Weekday(Date)) objMailItem.DeferredDeliveryTime = nxtMonday & " 07:00:00" Else objMailItem.DeferredDeliveryTime = DateAdd("n", 30, Now) End If End If End Sub |
If you find this code useful, or think you have a better way of doing this, drop me a line in the comments below!
Cheers
Mike
For those of you who are not fans of the latest version of the OS X Airport Utility, you can download the previous version (5.6) direct from the Apple support site.
Personally I think the new version strips away the advanced features of the Time Capsule set up. Which is perfect for some people, but how am I supposed to ‘tinker’ and break it without access to all the buttons!!
That’s right… Finally the boffins over at Apple have released the update all Time Capsule and Airport express iCloud users have been waiting for!
The latest version of firmware version 7.6.1 is available to download now!
This update is for all 802.11n AirPort Express, 802.11n AirPort Extreme and Time Capsule models. It fixes an issue with wireless performance and provides support for remote access to an AirPort disk or a Time Capsule hard drive with an iCloud account.
There has also been an update released for the Airport utility for OS X Lion. The new release is a full GUI redesign, switching it to look much more like the iOS version of the app. This is also available to download now!
Yesterday was a good day for the lucky guys over at Halfbrick Studios! The very popular (and free!) iOS game ‘Jetpack Joyride’ won the best mobile game of 2011 award! The game has received a consistent 4 1/2 star rating through each version released, with over 62793 Ratings on the current version, it’s clear to see it’s a popular download to in the iOS gaming world.
Winning an award like that against so many over titles really is something to be proud of! I must admit, I am not really an iOS gamer.. But there’s something about this which makes it really addictive.
Big congratulations on the award!
You can download Jetpack Joyride from the iTunes store now











