In our first hour
of today’s AutoHotkey webinar we talked about various ways you can automate MS Outlook. We covered the below scripts:
- Creating an HTML email (Also see this video)
- Performing mail-merge on the above HTML email
- Integrating a mail-merge from an active Excel file (Also see this video)
- Looping over emails in a folder
- Creating appointments in Outlook
- Creating an address book from looping over emails in Outlook
You can get the scripts here
The second hour dove a bit deeper into using Outlook and Excel. We also talked through a few user’s questions.
Below is the information that was reviewed in the PowerPoint deck we reviewed:
Script Highlight:
Sift by FanaticGuru uses Regular Expressions and nGrams* to fuzzy match strings
*n-gram is a contiguous sequence of n items
COM– Component Object Model
- What is COM?
- Some of the programs COM integrates with:
Creating an HTML email in Outlook with AutoHotkey
- Connect to Outlook or Create a new one (but may not deploy right then)
- Create a New Mail Item object
- Provide values for properties
- Specify Account Sending from
- Type of email (HTML, RTF, Text) (Search here for Outlook Constants)
- Identify Recipients: To, CC, BBC
- Subject line
- HTML Body
- Attachments
- Delivery time (Fuse)
- Request Delivery Reciept
- Importance
- Display / Send
- Convert above email to mail-merge with names & email addresses

Resources
AHK Forum:
MSDN resources:
Outlook examples on the-Automator
Stack Overflow
AutoHotkey webinar on COM & Excel