Excel to Outlook email automation
This VBA Excel macro is provided as a skeleton so you can send multiple emails from an Excel list, one email per row
You can also edit the code to suit your needs. This macro was written and tested in Excel 2007, Instructions:
Open the Excel file and enable macros
On sheet 1 enter the email details; from email address in column A, Subject in column B, etc…
If you want to add an attachment to your email enter a valid attachment path in column F otherwise leave it blank. If you enter an attachment path then he attachment path must be valid otherwise your macro will crash; you can add some error handling if you like to the code.
In column G select one of three options; send, toDraft or display.
Send will have the email sent without you seeing it on the screen. It can be found in your sent items.
toDraft will save the email in the draft folder in Outlook so you can send it later.
Display will generate and display the email, you can click send manually to send it later.
This program is provided as is with no warranty. No liability shall be taken for anything. By using this program you agree to these simple plain English conditions.
If you like something more advance that allows you to automate the creation of emails can include reports, graphs, text formatting and images in the email body then have a look at the advance version of this product here
This product was added to our catalog on Wednesday 24 November, 2010.