Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
RCV
QuickBooks Team
QuickBooks Team

Reply to message

Let me help you with printing your customer mailing labels in QuickBooks Online (QBO), tjc4photo.

 

We can click the Switch to classic view tab to run the Contact List report. This way, we can customize the report you need and not include every job on each customer. See the screenshot for your reference:

 

c1.PNGc2.PNG

 

Once done, we can export the contact list report to Excel. Just use the mail merge template in MS Word to create a mailing list. How to create a mailing list using the Contact List report. Here's how:

 

  1. In the Contact List report, select Customize, then Rows/Columns.
  2. Tap Change columns.
  3. Mark Full Name and any applicable address information you need, then Run Report.
  4. Click Export, then choose Export to Excel.

 

Then, edit the Excel file. Then proceed with the following:

 

  1. Open the Excel file.
  2. Delete all header rows from the spreadsheet. Make sure not to delete the column headings.
  3. Delete any extra leading columns to the left of the Full Name column.
  4. Review all records (rows) to make sure both Full Name and Billing Address are populated with data for each customer.
  5. Delete any rows you will not use in the address field. You don't need both billing and shipping.
  6. From the File tab, press Save As.

 

Once done, create a mail merge template in MS Word. You can create a mail merge template in MS Word. Check out Microsoft Office's website for detailed instructions. 

 

If you're having an issue with printing, you can read through these articles for your future reference:

 

 

Please know you can always come to the Community for all of your QuickBooks needs. I'll keep an eye out for your response.

Need to get in touch?

Contact us