
Over at Automated Word Mail Merge I have a sample workbook for creating a mail merge in Excel using VBA, but I've felt the example wasn't the best. So I produced another, and here it is.
Continue Reading: Mail Merge in Word+Excel using VBA »
The site formerly known as Code For Excel and Outlook

Over at Automated Word Mail Merge I have a sample workbook for creating a mail merge in Excel using VBA, but I've felt the example wasn't the best. So I produced another, and here it is.
Continue Reading: Mail Merge in Word+Excel using VBA »
Have you ever wanted to link Excel data to Outlook contacts? Here is a simple event handler that links cells on your Excel worksheet to data fields in Outlook's address book.
Continue Reading: Link Excel cells to Outlook data fields »

In previous articles I've written about how to extract information from webpages, and interact with them to navigate through a website.
This article won't strictly focus on IE, but on several collections available through the MSHTML Object Model.
Continue Reading: An exploration of IE browser methods, part III »

In Exploring the NOAA API I posted code for consuming the NOAA RSS feed for Atlantic storms.
I also posted weather-finding functions using the Geonames API, the WebserviceX.NET API and even a cheap formula for opening weather.com.
Continue Reading: State Weather Advisories available by RSS »
Here's a problem: You're automating Outlook in your Excel code (or any Office program for that matter), and need to find the value for an Outlook constant because you know you can't use built-in Outlook constants in late-bound Excel VBA code. How do you usually do it? Do an Internet search for the number?
Continue Reading: Finding Constant Values »
Follow Me