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

Can you print customer mailing labels in Quickbooks online?

 
12 Comments 12
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!

steve363
Level 1

Can you print customer mailing labels in Quickbooks online?

I`m glad you agree with " everybody" by saying that "I want QuickBooks Online to have this feature as much as you do" . So we will leave it in your capable hands to action this. Obviously you don`t want your customers wasting more time filling out forms to quickbooks about this when you already know about this massive oversight in your program. Please update us on how you are going with the fix. thank you.

pam-glohvac-com
Level 1

Can you print customer mailing labels in Quickbooks online?

I agree totally.  I am very frustrated with quickbooks online and also have been using the desktop version for about 30 years.  I need to get a mailing out yesterday...lol...and am still trying to figure out how to print the labels.

FaithA
QuickBooks Team

Can you print customer mailing labels in Quickbooks online?

I hear you, Pam. I know that this feature is important in managing your business needs.

 

Please know that we appreciate your insights and valuable feedback regarding our product. Rest assured, our dedicated product development team is continuously working to enhance the application while evaluating feature feasibility and potential benefits, based on user feedback. Previous suggestions about adding the ability to create customer mailing labels have been duly noted. 

 

Your input helps us prioritize features that align with your business needs. And we value your expertise and commitment to making our platform better. Here's how you can submit feedback to our product engineers:

 

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

 

You can track the status of your feedback and find recently updated ideas on our website Customer Feedback for QuickBooks Online.

 

Additionally, you might want to visit our QuickBooks Blog for the latest innovations and product news.

 

I'd also like to share this article that I believe might be useful in the future. Feel free to access it anytime: Memorize reports in QuickBooks Online.

 

You can count on the Community to address any questions you may have about printing preferences. Don’t hesitate to reach out—we’re here for you!

Kmorrisnc
Level 2

Can you print customer mailing labels in Quickbooks online?

The answer is STILL"not easily."  QB Desktop has this and its very simple.  It has built-in formatting  -- you just pick the Avery label style and it does it.  With QBO you have to generate a report, export it to Excel, then struggle to do a Mail Merge with Microsoft, which is incredibly difficult and not intuitive  (This also use to be easy and Microsift had a Wizard to guide you through it).  I am frickin sick and tired of software companies "upgrading" and making features that used to be easy very difficult.  Why do they feel they have to keep changing things?  Microsoft and Intuit are the worst offenders.

 

 

Kmorrisnc
Level 2

Can you print customer mailing labels in Quickbooks online?

The answer is STILL"not easily."  QB Desktop has this and its very simple.  It has built-in formatting  -- you just pick the Avery label style and it does it.  With QBO you have to generate a report, export it to Excel, then struggle to do a Mail Merge with Microsoft, which is incredibly difficult and not intuitive  (This also use to be easy and Microsift had a Wizard to guide you through it).  I am frickin sick and tired of software companies "upgrading" and making features that used to be easy very difficult.  Why do they feel they have to keep changing things?  Microsoft and Intuit are the worst offenders.

 

 

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

Need to get in touch?

Contact us