Mailing Labels

Below are instructions to create a mailing list and labels using the Contact List report in QuickBooks Online , MS Excel and MS Word. These instructions may vary dependent on the Microsoft Office Excel or Word versions that you may have. So, you may want to use the Help File in MS Excel or Word for more accurate instructions.

In QBO-from the Reports tab and click All Reports
Depending on which names you want to create a mailing list for, click Customers, Vendors, or Employees on the side menu. Scroll to the Contact List report.
Click Customize next to the report.
Click the Change Columns button.
Add Full Name and any applicable address information you need to the Selected Columns area.
Click OK, and then Run Report.
Click the Excel button at the top of the report, and save the report to your desktop.
Next, follow these steps in Microsoft (MS) Excel:

Open the report that you saved to your desktop.
Delete all header rows from the spreadsheet, leaving only column headings.
Delete any extra leading columns to the left of the Full Name column.
Review all records (rows) to make sure both Full Name and Billing Address are populated with data for each customer.
Delete any rows you will not be using in the address field (you do not need both billing and shipping).
Go to File, and then Save As. Save this spreadsheet under a different name, such as CustomerList.xls, to your desktop.
To create a mail merge template:

Review the Help Index (F1) in your specific version of MS Word. The following steps vary depending upon your version of MS Word.

Open MS Word, and open a new (blank) document.
Click Tools.
Select Letters and Mailings, and then Mail Merge.
Under "Select document type," click Labels.
Click Next.
Click Label Options to select the printer and the type of label.
Click Next.
Under "Select recipients," click Use an Existing List
Click Browse, and find the CustomerList.xls you saved to your desktop.
On the pop-up window for Table, Make sure check mark is in First Row of Data Contains Column Headers.
On the pop-up window for Mail Merge Recipients you should see your receipts listed in a table. Mark the records you wish to print. Check for duplicates.
Click Next.
In the Arrange Your Labels view, click on More Items.
Set the Insert Merge Field pop-up window as follows:
Set Insert Option to Database Fields.
Click Full Name and Insert.
Click Billing Address and Insert.
Click Close.
Now, working directly in the preview document, with the address field highlighted, you may click next to the address field, and use the enter key. Then the address field will be placed underneath the name field.

For Example:
<<Full_Name>>
<<Billing_Address>>

Steps to Replicate labels:

Click Update All Labels in Mail Merge Toolbar.
Click Next (Preview your labels).
You should now see the document loaded with your customer data in a label format.
 

Have a great weekend!

If you like this answer, please rate it!