Mail Merge is extremely simple in Word 2010 however it seems that because I don't use it as often, I always have to dig around and find out how to use it. Here are the step-by-step instructions on how to easily do mail merge.
1. Create an Excel Sheet with headers in the top row (i.e. Name | Address | Street | ST | Zip)
2. Populate the Excel sheet with the content. Save upon completion.
3. Open Word 2010
4. Click the Mailings tab.
5. Click Start Mail Merge and select Labels.
6. Select Label Vendor (i.e. Avery) and select Product Number (i.e. 5160 Easy Peel Address Labels). Click OK.
7. Click on the Select Recipients and select Use Existing List.
8. Browse and find your Excel Sheet and Click OK. Make sure that First row of data contains column headers is checked.
9. Make sure that your cursor is in the first label (the one that is empty and doesn't contain the <<Next Record>> tag).
10. Click Insert Merge Field and select the Labels that you want (i.e. Name, Address, etc)
11. Format to your liking (i.e. add spaces, new lines).
12. If your contents seem to be going off of the label when adding new lines, click the Home tab and under the paragraph portion click the Line and Paragraph Spacing (Up and Down arrow). Select Remove Space Before Paragraph. Note: your cursor needs to be at the beginning of the label (i.e. in this case before Name).
13. Go back to the Mailings tab and click Update Labels.
14. Click Finish & Merge and Select Edit Individual Documents.
15. Make sure that All is selected and click OK.
16. Insert paper into printer and click print.
Comments
Post a Comment