Print mailing labels using mail merge

Note: This article describes how to print custom mailing labels using mail merge with Microsoft Office. If you want to learn how to print mailing labels directly from Remine, click here.

Once you've tracked opportunities, sorted by labels, identified promising leads, and exported a CSV of your future clients, it's time to make contact. If you plan to send your communication via the postal system, you can use your Remine-generated CSV to produce mailing labels with Microsoft Excel and Word.

Click here for some letter templates that you can use to reach out to prospective clients.

Here's a quick video tutorial on how to use mail merge to create address labels:

Steps

For more granular instructions, including how you can use mail merge to create letters, see the Microsoft support article about using mail merge.

  1. Prepare your worksheet in Excel. Open your CSV file in Excel. Organize the worksheet with clear column names and your preferred capitalization and formatting. If you're working with a Remine-downloaded CSV, you'll want to focus on columns G through N (or R, if you want to identify more than one owner).

    Contacts.PNG

  2. Connect the Excel worksheet to your Word document. Open a blank Word document. On the Mailings tab, click Start Mail Merge. This is where you can select your document type, whether it be a full envelope, a sheet of labels, or something else.
  3. Refine the list of recipients. On the Mailings tab, click Select Recipients, then click Use an Existing List. Select your Excel worksheet that you prepared in step 1.

    On the Mailings tab, click Edit Recipient List. Select or clear the check boxes to customize the list of people to whom you want to reach out.

  4. Insert placeholders. These placeholders are called Mail Merge Fields, and they're populated by the data from your Excel worksheet when you finish the merge. If you're just creating mailing labels, on the Mailings tab, click Address Block.
  5. Preview and complete the merge. When you're done formatting your labels, on the Mailings tab, click Preview Results. Once you're happy with your labels, click Finish & Merge. From here, you can view individual labels and print.
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.