1. Click on Mailing on the ribbon.
2. Click start Mail Merge.
3. Select Normal Word Document.
4. Do steps 1-2 and this time select Step By Step Mail Merge Wizard.
5. It would then appear a Mail Merge task pane on your right you then select the document type in this case we select Letters.
6. Click Next.
7. Select Starting Document in our case we select the first one which is Use The Current Document.
8. Click Next.
9. Select Recipient, in our case we select Use An Existing List.
10. Click Browse.
11. You go and find the Excel page with the Names and Action in our case or which ever document you want to use.
12. Make sure to select sheet 1.
13. Make sure that at the bottom of this window on the left corner that the little box is check.
14. Click OK.
15. Select the entire Names and Actions on this sheet.
16. Click OK.
17. Click Next.
18. Select the area where your going to change the recipient in our case we select whatever is after Dear.
19. Once you select it click on More Items.
20. Then replace it with Names.
21. Then you go to the next line and whatever you put for the actions you select it.
22. Click on More Items once again.
23. Then replace it with Actions.
24. Click Next.
25. Preview your Letter to test it out with all the different recipients that you inserted.
26. Click Next.
26. You can now Print or Edit Indiviual Letters.
We can use this in many other ways one way is so that in the future if your company were to write a letter to many people but then you don't want to change the name for every letter this way it would save time. So you can change all the names with the Mail Merge and you can print very easily from the pages that you want to another.
No comments:
Post a Comment