How to change Ron de Bruin's code to include a list of email addresses

Good Morning,

I have an excel spreadsheet that I go into and send one tab of information to each recipient. There are 40+ tabs, and I would like to adjust Ron's code to include a tab with email addresses.

Ideally when I run the macro on each tab, I want the code to look at a separate tab called addresses, find the name on the particular tab that is to be mailed (in column A for example the tab name is XPW75) and check for the address that is associated with it (in column B), and proceed to send the e-mail.

Is this even possible??

This is the code currently...and it works perfectly with Groupwise. It creates the excel attachment, opens the new e-mail with the attachment inside. I just have to input the correct address "someone@somewhere.com".

Any geniuses out there, who can help a girl out??

Please Login or Register  to view this content.

There, there. Fear not, fair maiden!

Please Login or Register  to view this content.