Outlook - VBA Automatic E-Mails Sending from Excel
Originally published: 01/05/2020 08:41
Publication number: ELQ-65459-1
View all versions & Certificate
certified

Outlook - VBA Automatic E-Mails Sending from Excel

Send Automatic E-Mails from Excel with Outlook - VBA

Description
Send Automatic E-Mails from Excel with Outlook by just clicking in an email icon. This spreadsheet comes with a VBA code that allows the user to send emails in a intuitive and effective way. This is an ideal tool for those who need to send emails with a high frequency on a day to day basis - aiming at optimizing the user time.

The application is quite simple, there's an Outlook icon with an embedded VBA code on it, by clicking on the icon, your Outlook will open a display mode with the template information (e.g. To, CC, Subject and so on). Feel free to change the parameters as much as you want, the idea of this file is only to provide a template that you can personalize according to the task you want to perform.

This tool is ideal for routine tasks, for instance, if you need to send several emails per day and they have a similar structure.

By combining Excel, Outlook and VBA, this file provides an easy way to automate tasks that otherwise would consume a significant chunk of your time per day (considering the amount of emails a regular user sends on a daily basis).

This tool will help you to save time and to refocus on what really matters.

This Best Practice includes
1 Excel sheet

Rafael Buzin offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Send Automatic E-Mails from Excel with Outlook

Time optimization

For non routine emails


5.0 / 5 (1 votes)

please wait...