cancel
Showing results for 
Search instead for 
Did you mean: 
DHeraV
Moderator

Can you print customer address labels from Quickbooks?

Let me chime in on this thread, @office_manager.

I appreciate you performing the steps that my colleagues have provided above, and I'm here to share information about printing labels in QuickBooks Desktop (QBDT).

An outdated QuickBooks version can be one of the reasons why printing labels is behaving unusually. To isolate this, let's make sure your QuickBooks file is up-to-date.

Here's how to update:

1. Close your company file(s), then close QuickBooks.
2. Right-click the QuickBooks Desktop icon on your desktop, then select Run as administrator.
3. While on the No Company Open screen, go to the Help menu, then choose Update QuickBooks...
4. Go to the Options tab, and select Mark All. then select Save.
5. Go to the Update Now tab, then mark the Reset Update box.
6. Select the Get Updates button.

7. When Update Complete appears, close QuickBooks Desktop.
8. Reopen QuickBooks Desktop. If you get the message to install the update, select Yes.
9. When the installation is complete, restart your computer.

For detailed information, kindly visit: Update QuickBooks Desktop to the latest release.


Once the update is done, I recommend reviewing your customers' information. It could be that there are missing data in their profiles, that's why they're not showing when printing the labels in QBDT.

However, if the issue persists, I recommend running QuickFix my Program from the QuickBooks Tool Hub to repair possible damages in your QBDT file.

Moreover, I'll also share this link where you can search for articles that can serve as your reference in managing your QBDT file: QuickBooks Desktop Help Articles.

I'm looking forward to getting this resolved. Feel free to leave a reply if you require further assistance with printing labels in QBDT. The Community team always has your back. Keep safe. 

Taglotn
Level 1

Can you print customer address labels from Quickbooks?

I believe it just needs to be said that one cannot print mailing labels from QuickBooks Online.  The original question was about QBO although most of the rest of the thread is about Desktop.  I do not see an option called File.  And when I go to the Customer (Member in our case) Contact List all one gets is a spreadsheet-like list of customers and their details.  Hardly a label printing option.

AileneA
Moderator

Can you print customer address labels from Quickbooks?

Hello, Taglotn. 

 

The steps provided by my colleague are for QuickBooks Desktop, that's why you're unable to see the File option on your end since you're using QuickBooks Online.  

 

However, as a workaround, for printing labels from QuickBooks online, you need first to export your report file into an Excel file. After that, if you wish to edit your exported Excel Spreadsheet, then you can modify it as you require. Once the editing is done, click the Save As option in the File tab. 

 

Here's how: 

 

  1. Go to Reports.
  2. In the Search field at the upper right, choose a report.
  3. On the upper right, select Customize, then Rows/Columns.
  4. Select Change columns.
  5. Mark your Full Name and any applicable address information you need, then Run Report.
  6. Choose the Export icon.
  7. Click Export to Excel.

Then, we can modify the MS Excel file.

 

Here's how: 

 

  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. Make sure both Full Name and Billing Address are populated with data for each customer.
  5. Go to the File tab, then Save As.

 

Once completed, you can create a mail merge template in MS Word. Check Microsoft Office's website, they provide a step-by-step guide that will make it easy for you to set up your template. You can also refer to this article: How to create a mailing list using the mail merge feature of MS Word for further guidance. 

 

Though, I can see the convenience of having the print label function. However, this feature is currently unavailable. I recommend sending your feedback so our developers can consider adding this option in the future. To do so, please follow the steps below: 

 

  1. Click the Gear icon in the upper-right corner.
  2. Select Feedback under Profile.
  3. Share your feedback.
  4. Tap Next to submit.

 

Please know you can always come to the Community for your QuickBooks needs. I'll be here as soon as I can. Have a great day!

Trad
New Member

Can you print customer address labels from Quickbooks?

I have a customer who has multiple ship to addresses. When I go to print mailing labels, only one ship to prints. Please advise 

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

Need to get in touch?

Contact us