View source for Mailers Online:Print Labels

[[Mailers Online|&larr; Mailers Online]]
{{CustomTOC}}


Mailers Online - Print Labels in Microsoft Word - Mail Merge
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:

Create a Mailing Label.

How to merge the labels with a Recipient List (using the Mailers Online - Result file).

 

==Before You Begin==
<h3 class="productfield">Download & Extract Presorted File</h3>
:Once the Mailers Online file is purchased, it can be downloaded directly from the Mailers Online - Dashboard.

:Click "'''Report'''" and select "'''Download'''" in the bottom-right section of the page.


:[[File:MO_Print_01-Download.png|700px|alt=Download Button|link=]]

:Right-click the ZIP folder and select "'''Extract All'''".

:Extract your file from the the downloaded file. 


:[[File:MO_Print_02-Extract.png|700px|alt=Extract File|link=]]


:[[File:MO_Print_03-Extracted.png|700px|alt=Folder Contents|link=]]


<h3 class="productfield">Install USPS Font</h3>
If this is your first time doing a Mail Merge with the IMB®, perform the following steps to install the USPS4CB font.

Open the extracted folder and double-click on the file usps4cb.ttf to open the USPS Fonts.

Click "Install"


:[[File:MO_Print_04-FontInstall.png|700px|alt=Install Font|link=]]


==Open Word & Begin Mail Merge==
Open an existing Word document, or create a new one. 

 

Click the "Mailings" tab

Click the "Start Mail Merge" drop-down and select "Step-by-Step Mail Merge Wizard…"


:[[File:MO_Print_05-MailMerge.png|700px|alt=Start Mail Merge|link=]]


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. 


<h3 class="productfield">Step 1 - Select Document Type</h3>
Choose the type of document you want to create. 

For example, select "Labels"

Click Next: Starting document to move to Step 2.


:[[File:MO_Print_06-DocumentType.png|700px|alt=Select Labels|link=]]


<h3 class="productfield">Step 2 - Select Starting Document</h3>
Choose how you want to set up your mailing labels.

For example:

Click "Label options" and select the labels that you purchased. 

Select "Avery® US Letter – 15661 Easy Peel Address Labels" (Make sure the label you use is at least 1 inch x 3.5 inches.). 


:[[File:MO_Print_07-StartingDocument.png|700px|alt=Label Options|link=]]


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

 

<h3 class="productfield">Step 3 - Select Recipients</h3>
Select "Use an existing List" 

Click "Browse"

Open the Results file from the recently extracted Mailers Online folder.

Click "OK"

Click "Next: Arrange Your Labels"


:[[File:MO_Print_08-SelectRecipients.png|700px|alt=Select Recipients|link=]]


<h3 class="productfield">Step 4 -  Add Database Fields and Format Barcode</h3>
Add Database Fields by selecting "More Items" under "Arrange your Labels".

Select Insert: "Database Fields" 

Add each Field needed for Labels, in order.  Spacing can be adjusted after the desired fields are added. 


:[[File:MO_Print_09-AddFields.png|700px|alt=Insert Fields|link=]]


For example, 

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


:[[File:MO_Print_010-Example.png|700px|alt=Add Fields|link=]]


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»


:[[File:MO_Print_011-Example2.png|700px|alt=Highlight MD_IMBALPH|link=]]


Click "Update All Labels"

Click "Next: Complete the Merge"


<h3 class="productfield">Step 5 -  Complete the Merge & Print Labels</h3>
For example, 

Click "Print" 

Select Print Records: "All" options and click "OK"

Select Printer Name: "Microsoft Print to PDF" and click "OK"

Enter File Name to save as and click "Save"


:[[File:MO_Print_012-Complete.png|700px|alt=Print|link=]]

:[[File:MO_Print_013-Complete2.png|700px|alt=Merge to Printer|link=]]


<h3 class="productfield"></h3>
:

:*
*;



[[Category:Mailers Online]]