Welcome, joss0200.
Thanks for reaching out to the Community. In just a few easy steps you will be able print customer address labels.
First you'll need to export the Customer Contact List report to MS Excel:
- Go to Reports from the left menu.
- In the Search field at the upper right, enter Customer Contact List.
- On the upper right, press Customize, then Rows/Columns.
- Select Change columns.
- Check the Full Name box and any applicable address information you need, then click Run Report.
- Choose the Export icon.
- Click Export to Excel.
Now let's edit the MS Excel file. Here’s how:
- Open the Excel file.
- Delete all header rows and make sure not to delete the column headings.
- Delete any extra leading columns to the left of the Full Name column.
- Make sure both Full Name and Billing Address are populated with data for each customer.
- Go to the File tab, then click Save As.
Finally, you will need to create a mail merge template in Microsoft Word. This is a link that has detailed instructions on mail merging. Once finished, you can print it to where it will show your customer mailing labels.
Feel free to add a comment below if you have any more questions. Have a great rest of your week!