Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there, Monica33.
Right now, creating a customer mailing address in QuickBooks Online (QBO) isn't an option. For the time being, you can use the custom fields.
You can create one by going to the Custom fields menu.
Let me show you how:
I can see how this feature would be useful since it provides various tasks that need to be done. Please know that you can always submit a feature request to our product developers. Sharing features and options that you would like implemented is how our engineers look for new product updates.
To send feedback, follow the below steps:
You may also visit our Feedback forum page. From there, you can see a list of other QuickBooks users who already suggested this feature, as well as the recent updates in QuickBooks.
To learn more about personalizing transactions, see this article: Customize invoices, estimates, and sales receipts in QuickBooks Online.
For additional information, let me share some resources that you can browse and use as a reference in managing and navigating around your QuickBooks account.
Feel free to reach out to me if you need anything else. I'll be here to help. Have a good one!
I checked a previous post, saw that producing labels involved QBO export to Excel, and then use of the Mailings tab in MSWord. I stepped through these instructions myself, they work!
In QBO:
Reports > Customer contact list
Customize
Change columns
Unselect all but Customer and Billing Address
Run report
Export to Excel
Open file in Excel
Remove headers and any blank columns to the left of the data
Leave the column headings
Save the file
Open MSWord (to my shame, I am still using Word2013, but let's continue...)
Mailings > Start mail merge
Select Labels
In popup, select label vendor and product number to get proper dimensions, click ok
(for my test, I chose Avery A4/A5, Product no. 3422, a very common address label layout)
If label outline doesn't appear, go to Table Layout and select View Gridlines.
Mailings > Select recipients, Use an existing list
Select the file you just saved in Excel
Verify that box is checked for "First row of data contains column headers"
Click ok
All but the first label will display <<Next record>>
Mailings > Edit recipient list
Uncheck incomplete or duplicate records, click ok
Mailings > Insert merge field > Customer
Mailings > Insert merge field > Billing_Address
(repeat for any additional fields you have, of course)
Click into that first label, click inbetween Customer and Billing_Address
Tap enter to move Billing_Address to the next line.
Mailings> Update Labels (fields display in all labels)
Mailings > Preview results (fields are replaced with your customer data)
Print on paper, lay over labels to verify alignment
Print on labels.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here