cancel
Showing results for 
Search instead for 
Did you mean: 
kmj0597-hotmail-
Level 1

Can you print customer mailing labels in Quickbooks online?

 
7 Comments 7
Carneil_C
QuickBooks Team

Can you print customer mailing labels in Quickbooks online?

Yes, you can.

 

I'd be happy to guide you on how you can achieve your goal in QuickBooks Online.


To print customer mailing labels in QBO, let's run the Customer Contact List report and modify it to show the information you need, like their name and address.

 

To do so, here's how to do it:

 

  1. Go to Reports in the left menu and type in Customer Contact List on the search bar.
  2. Click the Customize button, then select the Change columns link.

     
  3. Check all the address boxes.
  4. Once done, tick Run report.
  5. From there, hit the Print icon beside the Export option.

 

In addition, here's an article you can review to help you more about personalizing your reports: Customize reports in QuickBooks Online.

 

Also, you can save its current customization setting for future use. You can check out this guide: Memorize Reports in QuickBooks Online.

 

I'm always ready to assist you if you have any other concerns about your transactions in QBO. Tag me in your reply, and I'll sprint back into action. Have a good one, and keep safe. 

tjc4photo
Level 1

Can you print customer mailing labels in Quickbooks online?

With the version of QBO I have (12/17/23), these instructions aren't giving me the outcome I want. When I search for "Customer Contact List", QBO runs a report that I'm trying to modify under the "Columns", but I have to either select the eye icon to hide or see the column. Additionally, it appears that EVERY job each customer has done is also on the list. Please help!

RCV
QuickBooks Team
QuickBooks Team

Can you print customer mailing labels in Quickbooks online?

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.

Kringleguy1
Level 1

Can you print customer mailing labels in Quickbooks online?

This information and any other responses like it on the Internet are just plain useless! I have used a variety of accounting programs over a thirty year time period during my working career and they all had built in label components or simple report writer programs that could use the accounting data to print mailing labels. I volunteer for a nonprofit that is moving (not up) to QB Online simply because of the support sunset for the QB Desktop 2019 program we have been using for many years. Desktop 2019 program has its own built in label making ability. Why didn't the creator gods of QB Online put that same ability in QBO if they are insistent on limiting their customer base to the use of QBO so they can increase their profits through the subscription software model of business? Since this simple improvement may never happen maybe it is time to find a QB equivalent that can produce the labels we need to mass mail our communications to our donors. 

Ethel_A
QuickBooks Team

Can you print customer mailing labels in Quickbooks online?

Hello there, @Kringleguy1.

 

I am aware of the advantages for businesses like yours to print labels. I want QuickBooks Online to have this feature as much as you do.

 

But this feature is not available in QuickBooks Online. However, I strongly urge you to share your thoughts with our software engineers. They carefully examine customer feedback, especially when determining how to improve QuickBooks.


Here's how:

 

  1. Sign in to your QuickBooks Online account.
  2. Go to the Gear icon and select Feedback.
  3. Type in your suggestion and click Next.

 

For future reference, if you want to print reports in QuickBooks Online, here are some resources you can read:

 

 

Feel free to comment below if you have questions about printing labels in QuickBooks Online. I'm always here to help. Have a great day.

Kmorrisnc
Level 2

Can you print customer mailing labels in Quickbooks online?

There are a LOT of QB Desktop users who use the print mailing label function.  Why is it necessary (with QB Online) to go through all those gyrations just to print to a sheet of labels.  Run report, export, mail merge, etc., etc.  Please add this feature.

BTW, QB Online is vastly inferior to QB Desktop.  One big deficiency is the inability to have MULTIPLE WINDOWS open in desktop.  QB Online doesn't allow that.

RoseJillB
QuickBooks Team

Can you print customer mailing labels in Quickbooks online?

Your feedback on accessing reports in QuickBooks Online (QBO) is valued, @Kmorrisnc. Know that we always want our customers to have the finest experience possible when pulling up data from the application.

 

I also understand how beneficial it is for everyone to have the ability to make customer mailing labels. In this regard, I suggest sending this suggestion to our product development team. Our product developers are responsible for evaluating and implementing new enhancements, so they would be better equipped to determine the feasibility and benefits of your suggestion for our users:

 

  1. Go to the Gear icon.
  2. Select Feedback.
  3. Enter a brief description of your product suggestion.
  4. Click Next to submit feedback. 

 

Furthermore, you have the option to use different financial reports to gain a quick overview of your business's financial progress. Additionally, I have included a resource that provides detailed instructions on how to customize these reports to your needs.

 

 

Please feel free to ask questions here if you need assistance. To do so, simply click the Reply button, and I'll be pleased to help. Take caution and remain safe!

Need to get in touch?

Contact us