Skip to content

Latest commit

 

History

History
17 lines (10 loc) · 715 Bytes

README.md

File metadata and controls

17 lines (10 loc) · 715 Bytes

Automatic-Email-VBA-Script

Short script that takes an excel sheet filled with names, companies, email addresses, CC's, and sends a customized message to each recipient.

This program was created for users who can not, or do not feel comfortable downloading macro enabled workbooks.

#Tutorial To run the program, open a new excel workbook.

Go to file -> options -> customize ribbon and check the "developer" checkbox

Go to the developer tab and click "Visual Basic", this will open the VBA IDE

Copy and paste the content from "AutomaticEmailScript.txt" into the code window

Follow the instructions in the green comments, including adding references and workbook formatting

Run the macro to send your emails!