Saturday, September 6th, 2008 255 views
Here is the last of the add-in code I was working on. This piece extracts the properties from Contact Items into Excel, using early binding to speed up the code, but with GetObject/CreateObject calls to attempt to hook into an existing instance of Outlook. What, do you mean you don't ...
Posted in Excel, Outlook, VBA, automation | No Comments »
Friday, August 29th, 2008 355 views
Here is part of the add-in code that exports Outlook Tasks into Excel. It works the same as the previous code that exports Calendar items, except we set a reference to the default Tasks folder (not Calendar), and I've also incorporated some new code which makes the sub more efficient ...
Posted in Excel, Outlook, VBA, automation | No Comments »
Monday, August 25th, 2008 208 views
Ever wanted to have an army of pre-formatted emails, which you can send at the click of a button, but couldn't figure out how to programmatically insert your signature at the end? Here's one method that should work for you.
First you should make a note of whether your signature is ...
Posted in Outlook, VBA | No Comments »
Monday, August 25th, 2008 40 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.
[vba]
Sub SaveEmailAttachments()
Dim Msg As Outlook.MailItem
Dim MsgColl As Object
Dim MsgAttach As Outlook.Attachments
Dim ...
Posted in Outlook, VBA | No Comments »
Sunday, August 10th, 2008 636 views
I completed some VBA code that will allow you to export appointment information (meetings, appointments) from Outlook into Excel. It requires a reference to the Outlook object library (unless you care to reengineer it), but it works even with Outlook closed. I think you'll find it very useful for when ...
Posted in Excel, Outlook, VBA, automation | 2 Comments »
