cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

How do I print customer address mailing list on labels?

 
3 Comments
Highlighted
QuickBooks Team

How do I print customer address mailing list on labels?

I can walk you through with printing the customer address labels, lazdins2.

 

Here's how:

  1. Click Reports
  2. In the Find report by name field, enter Customer Contact List.
  3. Click the Customize button, then add the fields or columns you need for the report.
  4. Click the Print icon, then click Print again.

Please check the screenshot below.

 

I'll be here if you have other concerns. Have a great day! 

Highlighted
Level 1

How do I print customer address mailing list on labels?

How do you print ADDRESS LABELS, not just a customer list with addresses on it?

 

Highlighted
QuickBooks Team

How do I print customer address mailing list on labels?

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:

 

  1. Go to Reports from the left menu.
  2. In the Search field at the upper right, enter Customer Contact List.
  3. On the upper right, press Customize, then Rows/Columns.
  4. Select Change columns.
  5. Check the Full Name box and any applicable address information you need, then click Run Report.
  6. Choose the Export icon.
  7. Click Export to Excel.

 

Now let's edit the MS Excel file. Here’s how:

 

  1. Open the Excel file.
  2. Delete all header rows and make sure not to delete the column headings.
  3. Delete any extra leading columns to the left of the Full Name column.
  4. Make sure both Full Name and Billing Address are populated with data for each customer.
  5. 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 to get in touch?

Contact us