Archive for August, 2008
Monday, August 25th, 2008 91 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 »
Friday, August 22nd, 2008 107 views
My son and his friends are really into Pokemon. After the initial disgust wore off, I noticed that the characters are all catalogued and classed into different categories, with different levels, strengths and abilities, so I went and found this cool color chart showing the effectiveness of different attacks on ...
Posted in Excel | 2 Comments »
Friday, August 15th, 2008 44 views
I finally registered for the 2008 East Coast Excel User Conference!
If you aren't familiar with the conference, Day One is for intermediate subjects, while Day Two is for more advanced subjects. So naturally being inclined to push my abilities as far as they can go, I opted for the more ...
Posted in Excel | 4 Comments »
Sunday, August 10th, 2008 1,028 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 | 4 Comments »
Tuesday, August 5th, 2008 176 views
As time goes on I am becoming more of a fan of modular programming. Lately I have been breaking out a lot of small code snippets into their own subs or UDFs. It's a great way to practice creating useful subs that can do different operations by passing arguments to ...
Posted in Excel, VBA | 3 Comments »