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

How do I print customers addresses onto Avery 5660 labels? I want to send out christmas cards

 
1 Comment 1
IrizA
QuickBooks Team

How do I print customers addresses onto Avery 5660 labels? I want to send out christmas cards

Printing your customer's address into Avery template will depend if you're using QuickBooks Online (QBO) or QuickBooks Desktop (QBDT), garnetblat. 


To begin, may I ask which product you are currently using? The reason I ask is that you've mentioned the Avery template, which is currently available exclusively for QuickBooks Desktop (QBDT).

 

If you intend to print customer addresses using the Avery Template in QBDT, please note that the available options are Print labels for inactive names, Print Ship To addresses where available, and Print labels for jobs. Kindly view the screenshot below: 

 

image.png

 

To assist you with this process, you can explore and utilize a third-party app by following these steps: 

 

  1. Go to Help menu, then choose App Center: Find More Business Solutions
  2. You can choose Features Applications tab or All Applications, then find your app from there. 
  3. You can also search the name of the applications by entering the app's name in the Search bar field. 

 

image.png

 

On the other hand, the Avery template and printing labels are currently unavailable in QuickBooks Online (QBO). As a workaround, you can export the Customer Contact List report, edit the downloaded file, and create a mail merge template in Microsoft Word.

 

Here's how: 

 

  1. Go to the Reports menu, then enter the Customer Contact List in the search field. 
  2. Modify your report by clicking the Columns icon and tick what you want to include in your report. 
  3. Once done, click the Export/Print icon, then hit the Download icon.  

 

After downloading the report, you can proceed with creating a mail-merge in word by visiting this article: Create a mailing list using the contact list report in QuickBooks Online
 

Please let me know if you have additional information regarding the steps above. I'll be here to offer further assistance.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us