- Make sure your Excel spreadsheet is format as follows:
- the field names should be on the first row
- every other row after that is a different record or a different transaction
- every column is a different field.
- Go into Microsoft Word.
- On the word document, click on the mailings menu.
- From the mailings menu click on Start mail merge.
- Click on labels.
- On the next screen, pick your label type
- Usually we would pick Avery US Letter as the label vendor
- Then you can pick any of the label size , the most popular one is 5160.
- Click on select recipients under the mailings menu, so you can tie in the Excel spreadsheet.
- Click on use an existing list.
- Point to your Excel spreadsheet in the Windows Explorer.
- Next, pick your sheeet that has your data
- Make sure you check where it says "first row of data containes column headers".
- Then click on OK.
- Select address block from the mailings menu.
- Select match fields from the insert address lock screen.
- Make sure all important fields have a matching field.
- Click on OK.
- Click OK again.
- Make sure you pick update labels.
- Pick finish and merge.
- Select edit individual documents
- Click Ok.
- You should now have mailing labels from your Excel data.
Tom Fragale
www.freepcseminars.com
(215)280-1073
tomfragale@gmail.com
