Need Help in Macro which sends sheets to their email ID

[KIM01]

Hi Friends,

I am seeking for help as i have one sheet which has sheets named on manager name and i want to send these sheets as attachment to managers as their email id is mentioned in EMail ID sheet.
Example on a click of button Patrik sheet should send to patrik and his email address is in Emaild sheet. same way Jeff sheet should be send to jeff as his email id is mentioned in Email id sheet.

Below is code which is i am using right know to send these sheet as attachment but every time i have to enter email address. which is time consuming specially when sheets are more than 50

Please Login or Register  to view this content.

Thanks for help
KIM

[maniacb]

Do the manager name(also on tab) and email have to be in the email spreadsheet, or can these two values be in the first two cells of each spreadsheet? Or will the tab name always equal the manager name and therefore mail tab has the list of each manager and email?

[maniacb]

Although I haven't received a response, I assume that the tab name always equals the manager name. With that in mind, I made the following changes to code, but now the new workbook does not contain the information from each manager. I need a real GURU to jump in here and finish this off. Please.

Please Login or Register  to view this content.

[maniacb]

Kim01, I believe the code will now address your requirements. Please note that you have to be very careful to align the tab names and their spelling with the email list on the "EMAIL ID" sheet. As an example, " Kelly" had a leading blank space and would not match the email list. I will update with other notes as they come to mind.
You can execute with the command button on the Email ID page.

Please Login or Register  to view this content.

After you test the code, remove the apostrophe from in front of the .send line and place it on the .Display line so that emails are sent without intervention.