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

Can i print customer mailing labels

can i print a list of customers mailing labels to be printed on avery labels?
5 Comments 5
Highlighted
Moderator

Can i print customer mailing labels

Hello dear, dlovett22 .

 

Yes, you can print the the mailing labels of your customer on Avery labels by. To do it, you'll have to manually add the name and address of the customer to Avery label. 

 

Let's run the the Customer Contact List report first and filter it to by customer's name and address. This way, you will have a copy of their information.

 

Please follow the steps below to do the process:

  1. From the left panel, click Reports.
  2. In the Search box, enter Customer Contact Lists report.
  3. Click  the Settings (small gear icon).
  4. Tick the Customer, Billing Address, Shipping Address box.

cc lists.PNG

 

You can visit here to learn more about customizing this report.  Also, if you're interested in exporting this report, you can click the Excel drop-down arrow and select Export to Excel.

cc export.PNG

 

I'll be around if you have more questions about this. I'd be happy to help you further. Have a great day! Take care!

Highlighted
Level 1

Can i print customer mailing labels

I get label pages like this....(attached) even though I just select Active customers....How do I get rid of the fields with bad info in them?

Highlighted
Moderator

Can i print customer mailing labels

Hi TJF1959,

 

You'll want to manually remove any other information once you've exported the report to an Excel file. I'll show you how.

 

  1. On the Customer Contact List report page, click on the export icon.
  2. Choose Export to Excel.
  3. On the Excel file, press the Ctrl + F keys.
  4. Type in MS and go to the Replace tab.
  5. Click on Replace All.

In case you want to customize a report, refer to this article: Customize your reports in QuickBooks Online.

 

Reach out to us if you have further questions. We're here to help. Have a good one.

Highlighted
Level 1

Can i print customer mailing labels

How do I get the cleaned up excel file back in quickbooks to use?

Highlighted
QuickBooks Team

Can i print customer mailing labels

I do have the steps on how you can import the customer information back into QuickBooks, TJF1959.

 

Before doing so, make sure you have the following columns on your  Excel spreadsheet:

  • Full Name
  • Company
  • Email
  • Phone
  • Mobile
  • Fax
  • Website
  • Street
  • City
  • State
  • ZIP code
  • Country
  • Opening Balance
  • Date
  • Resale Number

Then, follow these steps to import the customer list:

 

  1. Go to the Gear > Tools > Import Data.
  2. In the Import Data page, select the Customer box.
  3. Choose the file by clicking the Browse button, and then select Next.
  4. Map the columns and click Next.
  5. Check the customers you want to import, and then select Import.

Please see this sample screenshot for a visual guide:

import customer data.JPG

 

Once done, you can go to the Customers page under Sales to see the imported customers or run the Customer Contact List report.

 

I'm also adding this article for reference: Import customer or vendor contacts from Outlook, Excel or Gmail.

 

Please get back to me if you have additional questions or concerns related to customers in QuickBooks. Have a good day!

Need to get in touch?

Contact us