thanks... now that I have it working, my follow on question.
In my outlook template there are fields for Greeting, Meeting Date, Next Meeting Date and Time.
Is it possible to take these fields from the excel spreadsheet and populate the fields in the template? (i.e. like a mail merge of sorts)
I have an excel macro that creates an email in outlook using a template. Col A is the email address; Col B is the subject. The macro works, except when it loops through the list, instead of creating a new email and saving it as a draft, it overwrites the email.
Thanks... I've made some progress.... The macro code is below. It's only creating the entry on the last line from the excel sheet. I decided to start with Excel and run a macro to create an outlook message based on a template. column 1 is the email address, column 2 is the email subject. any...
I found the macro that takes fields from excel and sends an email.
I would like to create an email from an outlook template, populate fields from excel and save it as a draft.
Here's the outlook/VBA macro - I'd like to pull from excel the following columns:
Email Address, Meeting Date, First...