Define e-mail adresses to send e-mail

[ncaravela]

Hi everybody,

I have the following VBA code that allows me to send and e-mail with the active sheet of a workbook from Excel. It works great, but i have one question...something i can't resolve.

Every sheet has specified e-mail adresses but i can't sort is out.

For example: i want that the active sheet 1 goes to A; the active sheet 2 goes to B, etc...

Can anyone help me?

Please Login or Register  to view this content.