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!
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.