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



Once you add all your fields, click "Close" .

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.




Format the Intelligent Mail Barcode by highlighting the MD_IMBALPH field and change the font to USPS4CB.

Highlight the MD_IMBAlphaCode field and right click, then select font and choose usps4cb and size 16.

Click "OK" or press Enter.

«MD_IMBAlphaCode»









Click "Update All Labels"

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".