Controlling Outlook from Excel (full version)

Description
Linking Excel to Outlook will be useful if you:

1. Prepare regular reports and send them out by e-mail.
2. Receive information by e-mail which you then download and process for further analysis and reporting.

You can automate both process with Excel VBA and save your time. You can also integrate them into your existing VBA routines, thus making a smooth and efficient data processing process.

This post contains examples of working with Outlook through Excel. After studying these examples you will be able to adjust them to your requirements or build completely new applications.

This post contains two files:

1. A file sending emails from Excel

You can choose recipients (including cc and bcc recipients), define subject and body text of your e-mails, insert file attachments, include rich-text tables, embedded pictures from Excel cell ranges, shapes from the sheet and pictures from the file, request a read receipt. You can choose to preview an e-mail before it is sent or to fire it immediately as you push the button.

2. A file reading emails in Excel

This file demonstrates how Excel can access Outlook folders, browse through emails and retrieve their senders, recipient, subject, message body and attachments. It can also reply, forward and even delete selected emails.

There is a demo version (fully functional but with locked VBA code) available for free at this link: https://www.eloquens.com/tool/g2Y2IDPD/andrei-okhlopkov/controlling-outlook-from-excel-short-version

The files contain VBA macros, so make sure you have macros enabled when opening the files.