Email using multiple sheet in excel

[Realme]

Dear Mrexcel,

My query is can we send email through excel using multiple sheet.
For Example :
Excel File Contain
WorkSheet
Sheet 1 Sheet 2 Sheet 3 untill Sheet 100 all sheet has different email
This email is reminder as time sheet to the employee, so i would like to send email should go to employee as per his / her email
Likewise sheet 1 has employee A email address it means sheet 1 should go as an email to Employee A like Employee B and C and go and on and on.

Is there useful way to send email to various employees using multiple sheet.

This solution help lots of time saving.

Looking forward to hear from you.

Thanks,

Realme

 

[tzvett]

Hello, I am joining the thread asking for help. I need a code to email each individual sheet of the book, putting for a name, the name of the sheet itself and sending it to an email address that is located in cell A1 in each sheet.

I'd love it if you could help me!

 

[kevin9999]

Hello, I am joining the thread asking for help. I need a code to email each individual sheet of the book, putting for a name, the name of the sheet itself and sending it to an email address that is located in cell A1 in each sheet.

I'd love it if you could help me!

You will have to start a new thread.