Macro to email sheets to many users

Hello All,

I am trying to automate a manual task to email sheets in a workbook to many users. Hope you can help me here.

Attached file is the sample file.

The sheet "Master Sheet" has list of users, their email Ids and their respective the sheet name "begins with" should be attached. Users will have mutiple sheets to be attached.

The Master sheet also has email contents like CC, Subject line , Body of the email which will be standard for all the users excpect for the employee name.

I am trying to automate a manual task...

An XLSX file cannot contain any code - you will get help faster if you post your attempt so far. In the absence of any code, go search the forum (or elsewhere) - emailing with VBA is a very common task. Once you have basic code then it's easy to refine to your exact requirements.

Hi cytop,

Thanks for the advise. I am able to find the below code in this forum which is closer to what I am looking for, but requires few changes. Instead of PDF file, i want in excel format and emails IDs should be referred from master sheet intead of individual sheets. Some users will have multiple tabs to be attached in sinlge email.

Can you please help to modify this code.

Please Login or Register  to view this content.