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

Controlling Outlook from Excel (full 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

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.

This Best Practice includes
2 Excel files

Acquire business license for $25.00

Add to cart

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

  • Be the first to review this Downloadable Best Practice

    Write a review


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 (full Version)?

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


0.0 / 5 (0 votes)

please wait...