Time to Learn
Follow
Find
1.3M views | +343 today
 
Scooped by Frédéric DEBAILLEUL
onto Time to Learn
Scoop.it!

Send mails using VBA and Outlook - How to send emails using Excel

Send mails using VBA and Outlook - How to send emails using Excel | Time to Learn | Scoop.it

In this article we well learn how to use VBA and Microsoft Outlook to send emails with your reports as attachment.

Scenario

We have an excel based reporting template for the Customer Service Dashboard. We want to update this template using VBA code to create a static version and email it to a list of people. We will define the recipient list in a separate sheet.

Features

1. Code will automatically create necessary folders to save the output file.
2. Email sheet to contain the list of people who are going to receive the report.
3. Sending mail using Microsoft Outlook, primary target is corporate people who are using Outlook as their mail program.

more...
No comment yet.
Time to Learn
Environnement d'Apprentissage Collaboratif
Curated by Frédéric DEBAILLEUL