Tuesday, July 15th, 2008 20 views
If you have been using the code I wrote that duplicates the "Resend This Message" functionality, you may have run into a small problem when executing the code repeatedly on subsequent messages.
Resend This Message
For example, you might execute the code on Message #1 in order to resend it to the ...
Posted in Outlook, VBA | No Comments »
Friday, May 30th, 2008 193 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 180 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 | No Comments »
Friday, May 23rd, 2008 140 views
Here's a sub and a function for Outlook that let's you save attachments from a selected or open email. It's similar to the File>Save Attachments menu option, which lets you save all of the attachments from a particular email, or the FindControl Method, which can be used to find and ...
Posted in Outlook, VBA, automation | No Comments »
Thursday, May 22nd, 2008 89 views
I recently discovered a new object library that seems pretty useful - the Microsoft Office Document Imaging Type Library. From the MSDN site:
The Microsoft® Office Document Imaging 2003 (MODI) object model makes it possible to develop custom applications for managing document images (such as scanned and faxed documents) and the ...
Posted in Outlook, VBA, automation | No Comments »
Tuesday, May 13th, 2008 113 views
Here is the finished code for the Outlook File Request System.File Server CodeThis is event code which acts as an automated file server, putting files into the specified folder, and sending files back to the requestor, all via email. Once the code is installed, another user requests a file from ...
Posted in Outlook, VBA, automation | No Comments »
Saturday, May 3rd, 2008 13 views
I've been mentioning the Excel training class for some time now, finally the curriculum is coming together and I finally got off my lazy butt and have almost completed the handouts and sample worksheets. I am hoping with fingers crossed to have this finally completed by the end of next ...
Posted in Outlook, Tutorial, VBA, automation | No Comments »
Sunday, April 27th, 2008 48 views
Here is the event code I promised for forwarding emails to another email address. It does exactly the same thing as the previous code, but since it is event code, once you place it in a class module and restart Outlook, it runs automatically without any need for you to ...
Posted in Outlook, VBA, automation | 2 Comments »
Thursday, April 17th, 2008 59 views
Greetings,
I would like to share some code I wrote last month for a user who visited my website and asked for a macro that would look for specific text in the subject of an email and forward it to another email address (in this case, an email for a mobile ...
Posted in Outlook, VBA | No Comments »
Monday, April 14th, 2008 121 views
About halfway down the Outlook page, there is some VBA code for opening an Excel workbook attached to an email, running a macro on it, then cleaning up and moving the email to another folder.
Here is some more sample code to make your macro even more intelligent. This code opens ...
Posted in Excel, Outlook, VBA, automation | No Comments »
