Controlling Outlook from Excel (short version)
Originally published: 30/05/2020 07:42
Last version published: 11/03/2021 08:53
Publication number: ELQ-47926-3
View all versions & Certificate
certified

Controlling Outlook from Excel (short version)

Connecting Excel to Outlook programmatically

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 (short unlocked version)

You can choose recipients (including cc and bcc recipients), define subject and body text of your e-mails, insert file attachments, 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 demo version of an extended file sending and reading emails (fully functional but with locked VBA code)

This file allows to include rich-text tables, embedded pictures from Excel cell ranges, shapes from the sheet and pictures from the file. It also 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.

An unlocked version of this file is available at this link: https://www.eloquens.com/tool/GbEvc3lj/finance/excel-vba-tutorials/controlling-outlook-from-excel-full-version

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

This Best Practice includes
2 Excel files

Andrei Okhlopkov offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

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

n/a

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Andrei Okhlopkov

See all
keyboard_arrow_leftkeyboard_arrow_right

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

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


4.6 / 5 (8 votes)

please wait...