Mailing worksheets in excel

[Bruno1250]

Hi All,
I have an excel workbook with 170 worksheets.
Each worksheet has feedback on project work for individual students.
What I would like to do is send individual worksheets to individual students.
E.g. I want to send worksheets 1 to student email address No.1 and worksheet 2 to student email No.2 and so on up to worksheet 170 to student 170.
Is this possible? Any help appreciated.

[#2]

Hello @Bruno1250,

Please refer to the following to learn how to send a single worksheet as an email attachment.

https://trumpexcel.com/send-single-excel-worksheet-email-attachment/

[#3]

Thanks for the link. That will work for me but I will have to do it 170 times. I am hoping to find a way of doing it more efficiently. Thanks again:thumbs_up:

[#4]

@Bruno1250 

This would be possible with a macro. I am not well-versed in VBA so I will defer a suggestion for a code to the rest of the community.

Maybe this could at least start you in the right direction:

https://www.mrexcel.com/board/threads/macro-to-e-mail-different-sheets-to-different-e-mail-addresses...

[#5]

That looks promising. I’ll see what I can find there. Thanks for the link.