Mailers Online:Print Labels

← Mailers Online

Mailers Online returns a Result file that can be uploaded into Microsoft Word’s - Mail Merge to Print Labels.

The following example demonstrates how to:

1. Create a Mailing Label.
2. How to merge the labels with a Recipient List (using the Mailers Online - Result file).

Before You Begin

Download & Extract Presorted File

1. Once the Mailers Online file is purchased, it can be downloaded directly from the Mailers Online - Dashboard.
2. Click "Report" and select "Download" in the bottom-right section of the page.



3. Right-click the ZIP folder and select "Extract All".
4. Extract your file from the the downloaded file.

Install USPS Font

If this is your first time doing a Mail Merge with the IMB®, perform the following steps to install the USPS4CB font.

1. Open the extracted folder and double-click on the file usps4cb.ttf to open the USPS Fonts.
2. Click "Install"

Open Word & Begin Mail Merge

Open an existing Word document, or create a new one.

1. Click the "Mailings" tab.
2. Click the "Start Mail Merge" drop-down and select "Step-by-Step Mail Merge Wizard…"



The Mail Merge will appear and guide you through the six (6) main steps to complete a merge. The following example demonstrates how to create a mailing label and merge the labels with a recipient list.

Step 1 - Select Document Type

1. Choose the type of document you want to create.

For example, select "Labels"

2. Click Next: Starting document to move to Step 2.

Step 2 - Select Starting Document

Choose how you want to set up your mailing labels. For example:
1. Click "Label options" and select the labels that you purchased.
2. Select "Avery® US Letter – 15661 Easy Peel Address Labels" (Make sure the label you use is at least 1 inch x 3.5 inches.).



3. Click "Next: Select recipients to move to Step 3".

Step 3 - Select Recipients

1. Select "Use an existing List"
2. Click "Browse".
3. Open the Results file from the recently extracted Mailers Online folder.
4. Click "OK".
5. Click "Next: Arrange Your Labels".

Step 4 - Add Database Fields and Format Barcode

1. Add Database Fields by selecting "More Items" under "Arrange your Labels".
2. Select Insert: "Database Fields".
3. Add each Field needed for Labels, in order. Spacing can be adjusted after the desired fields are added.




For example: Add: Endorsement, FirstName, LastName, Address, City, State, Zip, Plus4, IMBAlphaCode



4. Once you add all your fields, click "Close".
5. Add the spaces and separate each address line.
Example 1:

«MD_IMBAlphaCode»
«MD_Endorsement»
«MD_NameFirst» «MD_NameLast»
«MD_Address1»
«MD_City» «MD_State» «MD_PostalCode»-«MD_Plus4»

Example 2:

«MD_IMBAlphaCode»
«MD_NameFirst» «MD_NameLast»
«MD_Address1» «MD_Suite»
«MD_City» «MD_State» «MD_PostalCode»-«MD_Plus4»


An Intelligent Mail barcode is required to claim automation prices.

• All mail claimed at automation prices must bear an Intelligent Mail barcode in either the Address Block or the Barcode Clear Zone.
• If mail piece weighs more than 3 ounces, the barcode must be included in the Address Block.
6. Format the Intelligent Mail Barcode by highlighting the MD_IMBALPH field and change the font to USPS4CB.
7. Highlight the MD_IMBAlphaCode field and right click, then select font and choose usps4cb and size 16.
8. Click "OK" or press Enter.

«MD_IMBAlphaCode»









9. Click "Update All Labels".
10. Click "Next: Complete the Merge".

Step 5 - Complete the Merge & Print Labels

For example:
1. Click "Print".
2. Select Print Records: "All" options and click "OK".
3. Select Printer Name: "Microsoft Print to PDF" and click "OK".
4. Enter File Name to save as and click "Save".