The site formerly known as Code For Excel and Outlook
So I decided to test another assumption of mine: that Len is the fastest method for checking the length of a string, and therefore if a string variable is empty. The next series of posts will explore that in more detail.
Continue Reading: Len or Loop »
July 22, 2011 by · 
In my quest to optimize my Access queries, I wanted to view the underlying SQL for each query. However I have dozens of queries and manually examining each one is a hardship. Here's how I did it with VBA.
Continue Reading: List all MS Access queries in database »
August 25, 2008 by · 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.
Continue Reading: Processing multiple emails »
Site last updated: February 8, 2012
Follow Me