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:
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.
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!
You'll want to manually remove any other information once you've exported the report to an Excel file. I'll show you how.
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.
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:
Then, follow these steps to import the customer list:
Please see this sample screenshot for a visual guide:
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!