Outlook - VBA Automatic E-Mails Sending from Excel

Send Automatic E-Mails from Excel with Outlook - VBA

by Rafael Buzin
Planning & Performance Associate DirectorFollow

1 review265 views|Start the discussion!|Bookmark download for free

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