Question

Write steps to create Student Annual Report using mail merge with spreadsheet?

Answer 1

We can merge the mail with spreadsheet using following steps,

1. Create a spreadsheet with Students Annual Report, which contains students name and their respective marks in each subject.

2. Save the spreadsheet with unique name.

3. Open the “Mailings” tab, click “Start Mail Merge” drop down box and select “E-mail Message”.

4. Click the “Select Recipients”, and select the required recipient. We can select the existing list or create a new list.

5. Write the letter with required data.

6. Preview the letter for each recipient in “Preview Your Letter” box.

7. In “Finish & Merge” drop down box. We can print or edit the letter.

Answer 2

Answer:

usussixydhcuislduc8odod9