Monday, August 25th, 2008 14 views
In Highlight And Move Multiple Emails, I demonstrated a technique for processing several emails at once and moving them to another folder. Here is another example that shows how you can save attachments from several selected emails, then delete them.
Sub SaveEmailAttachments()
Dim Msg As Outlook.MailItem
Dim MsgColl As Object
Dim MsgAttach As Outlook.Attachments
Dim ...
Posted in Outlook, VBA | No Comments »
Tuesday, June 24th, 2008 2,044 views
In the spirit of my last post Calculate Working Days Minus Holidays in VBA, here is a function I wrote recently that returns the number of working hours between two date/time values passed to the function as arguments. It is self-contained and works independently of whatever existing code you have, ...
Posted in Excel, UDF, VBA | 6 Comments »
Tuesday, June 17th, 2008 1,004 views
I was looking for a function that calculates working days, minus holidays, for a small project I've been working on. I decided to write one myself, but below I've also demonstrated an alternate way that uses the ATP (Analysis ToolPak) functions for VBA.
Function WorkDays(StartDate As Variant, EndDate As Variant) ...
Posted in Excel, UDF, VBA | 3 Comments »
Friday, May 30th, 2008 272 views
Okay so I said I would be writing some VBA code to export contacts and emails from Outlook to Excel, well, I lied, sort of. That code is still coming, but before I post it, here is a routine that lets you run VBA code on multiple messages at the ...
Posted in Outlook, VBA | No Comments »
Thursday, May 29th, 2008 268 views
I was inspired to write some VBA code that lets you open any attachment in its native application by a recent newsgroup post from Outlook MVP Sue Mosher. The truth is I was bored, and it was easy to code because I simply reused code I had just written for ...
Posted in Outlook, VBA, automation | 3 Comments »
