Controlling Outlook from Excel (short version)
  • Controlling Outlook from Excel (short version)
Originally published: 30/05/2020 07:42
Last version published: 30/05/2020 10:33
Publication number: ELQ-47926-2
View all versions & Certificate

Controlling Outlook from Excel (short version)

Explains how to programmatically link Excel to Outlook

In this post I will explain how to programmatically link Excel to Outlook. If you perform Excel calculations which you need to share with others by e-mail or if you receive e-mails with files which you use further in your analysis you will find these materials useful. They cover two major areas:

1. Sending e-mails from Excel

This file contains the VB code which allows sending e-mails from Excel. You can choose the recipients (including cc and bcc recipients), include attachments, define subject and body text of your e-mails, 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. Working with e-mails received

This part shows how to access specific Outlook folders, browse through e-mails, make replies and forwards, open or save attachments – all automated with a code from Excel.

As a bonus, this part shows how to use custom pop-up menus in an advanced manner.

These materials are split into two posts:

Short version (this one) includes:
Sending e-mails – fully functional unlocked file
Working with e-mails received – demo version, fully functional but with VBA code locked

There is a full version available on my channel which includes a complete unlocked file with both functionalities:

This Best Practice includes
2 Excel files

Andrei Okhlopkov offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

Automate information exchange between Excel and Outlook

If you process information in Excel and need to send it out by e-mails to users or if you receive data by e-mail which you use further in your analyses




More Best Practices from Andrei Okhlopkov

See all

Any questions on Controlling Outlook From Excel (short Version)?

The user community and author are here to help. Go ahead!

4.5 / 5 (6 votes)

please wait...