Home

Mailing worksheets in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1201397%22%20slang%3D%22en-US%22%3EMailing%20worksheets%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1201397%22%20slang%3D%22en-US%22%3EHi%20All%2C%3CBR%20%2F%3EI%20have%20an%20excel%20workbook%20with%20170%20worksheets.%3CBR%20%2F%3EEach%20worksheet%20has%20feedback%20on%20project%20work%20for%20individual%20students.%3CBR%20%2F%3EWhat%20I%20would%20like%20to%20do%20is%20send%20individual%20worksheets%20to%20individual%20students.%3CBR%20%2F%3EE.g.%20I%20want%20to%20send%20worksheets%201%20to%20student%20email%20address%20No.1%20and%20worksheet%202%20to%20student%20email%20No.2%20and%20so%20on%20up%20to%20worksheet%20170%20to%20student%20170.%3CBR%20%2F%3EIs%20this%20possible%3F%20Any%20help%20appreciated.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1201397%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1201409%22%20slang%3D%22en-US%22%3ERe%3A%20Mailing%20worksheets%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1201409%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570861%22%20target%3D%22_blank%22%3E%40Bruno1250%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20refer%20to%20the%20following%20to%20learn%20how%20to%20send%20a%20single%20worksheet%20as%20an%20email%20attachment.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fsend-single-excel-worksheet-email-attachment%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrumpexcel.com%2Fsend-single-excel-worksheet-email-attachment%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1201512%22%20slang%3D%22en-US%22%3ERe%3A%20Mailing%20worksheets%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1201512%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20link.%20That%20will%20work%20for%20me%20but%20I%20will%20have%20to%20do%20it%20170%20times.%20I%20am%20hoping%20to%20find%20a%20way%20of%20doing%20it%20more%20efficiently.%20Thanks%20again%3Athumbs_up%3A%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1201619%22%20slang%3D%22en-US%22%3ERe%3A%20Mailing%20worksheets%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1201619%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570861%22%20target%3D%22_blank%22%3E%40Bruno1250%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20would%20be%20possible%20with%20a%20macro.%20I%20am%20not%20well-versed%20in%20VBA%20so%20I%20will%20defer%20a%20suggestion%20for%20a%20code%20to%20the%20rest%20of%20the%20community.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20this%20could%20at%20least%20start%20you%20in%20the%20right%20direction%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mrexcel.com%2Fboard%2Fthreads%2Fmacro-to-e-mail-different-sheets-to-different-e-mail-addresses.643655%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mrexcel.com%2Fboard%2Fthreads%2Fmacro-to-e-mail-different-sheets-to-different-e-mail-addresses.643655%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1201626%22%20slang%3D%22en-US%22%3ERe%3A%20Mailing%20worksheets%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1201626%22%20slang%3D%22en-US%22%3EThat%20looks%20promising.%20I%E2%80%99ll%20see%20what%20I%20can%20find%20there.%20Thanks%20for%20the%20link.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
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.
4 Replies
Highlighted

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/

Highlighted
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
Highlighted

@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...

Highlighted
That looks promising. I’ll see what I can find there. Thanks for the link.
Related Conversations
Removing unnecesary characters
Ocasio27 in Excel on
0 Replies
Excell spread sheet
CDeyzel1600 in Excel on
1 Replies
unable to open an excel file
keithsmarathon in Excel on
0 Replies
ABOUT PRIVATE CODE NUMBERS
radixanaliz in Excel on
1 Replies
Erro ao tentar usar o SOMASE
elton_janz in Excel on
0 Replies