Tuesday, May 13th, 2008 149 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 »
Tuesday, April 29th, 2008 128 views
One of the most popular pages on this site shows code for automating Internet Explorer. However I have only tested the code in Excel XP/2003. The purpose of this post is to credit a gentleman named Durand Sinclair who, using Excel 2007, pointed out to me that the name of ...
Posted in Excel, Internet Explorer, VBA, automation | 2 Comments »
Sunday, April 27th, 2008 70 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 | 4 Comments »
Monday, April 14th, 2008 222 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 »
Saturday, March 29th, 2008 218 views
Greetings,
I just updated the site with some code for automating the mail merge to Word process. Check it out here:
Excel Mail Merge
Enjoy,
JP
Posted in Excel, VBA, Word, automation | No Comments »
