Mail merge in excel

[Khairul Islam]

I have created a excel format of students mark sheet. There are 15 student, and so there are 15 excel sheets in a excel file. I have email address of 15 student as well. I want to send those 15 mark sheet to each student using mail merge at a single click. Please assist me. Many thanks.

 

[EFANYoutube]

This might seem lazy of me but I think the answer to your question has been very very well documented, please see below the link that will help you with everything your trying to.
You will have to change how your data is stored because a mail merge comes from a table of data and auto fills a template, in your case with names and individual marks etc
If you have issues after that i'd be happy to help

Mail merge using an Excel spreadsheet - Microsoft Support

How to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents.

support.microsoft.com

 

[Khairul Islam]

This might seem lazy of me but I think the answer to your question has been very very well documented, please see below the link that will help you with everything your trying to.
You will have to change how your data is stored because a mail merge comes from a table of data and auto fills a template, in your case with names and individual marks etc
If you have issues after that i'd be happy to help

Mail merge using an Excel spreadsheet - Microsoft Support

How to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents.

support.microsoft.com

Thanks bro. One thing, can I send the attachment as pdf with password protected.