Hi All
Sorry if this has already been covered but I have been searching for ages for the answer and could not find it
.
I am looking for a macro that will send seperate e-mails for each worksheet I have in my workbook, I am using office 2007 but would like the attachments to be sent in excel 97-2003,
It will need to vlookup against an excel spreadsheet for the e-mail addresses i.e.
Tab Names:
123 456 789
-- removed inline image ---
I could add a tab with the e-mail addresses on if it would make the code easier.
Many thanks in advance
Wizfold
Sorry if this has already been covered but I have been searching for ages for the answer and could not find it
.I am looking for a macro that will send seperate e-mails for each worksheet I have in my workbook, I am using office 2007 but would like the attachments to be sent in excel 97-2003,
It will need to vlookup against an excel spreadsheet for the e-mail addresses i.e.
Tab Names:
123 456 789
-- removed inline image ---
I could add a tab with the e-mail addresses on if it would make the code easier.
Many thanks in advance
Wizfold
