QuickBooks HelpQuickBooksHelpIntuit

How to create a mailing list using the Contact List report

SOLVEDby QuickBooksQuickBooks Online3Updated 7 days ago

Quickly create a mailing list using the Contact List report in QuickBooks Online. When you export the contact list report to Excel, you can then use the mail merge template in MS Word to create a mailing list.

How to create a mailing list using the Contact List report

Step 1: Export the report to MS Excel. Then proceed with the following steps:

  1. Go to Business overview and select Reports (Take me there).
  2. In the Search field at the upper right, enter the Contact List report.
  3. Select the report from the results.
  4. On the upper right, select Customize, then Rows/Columns.
  5. Select Change columns.
  6. Mark Full Name and any applicable address information you need, then Run Report.
  7. Select Export, then choose Export to Excel.

Step 2: Edit the MS Excel file. Then proceed with the following:

  • Open the Excel file.
  • Delete all header rows from the spreadsheet. Make sure not to delete the 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 use in the address field. You don't need both billing and shipping.
  • From the File tab, select Save As.

Step 3: Create a mail merge template in MS Word

You can create a mail merge template in MS Word.

Note: These steps may vary depending on the Microsoft version you're using.

That's it. You now know how to create a mailing list using the Contact List report.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this