Mailers Online:Print Labels

From Melissa Data Wiki
Jump to navigation Jump to search

← 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. Download Button
  4. Right-click the ZIP folder and select "Extract All".
  5. Extract your file from the the downloaded file.

  6. Extract File
    Folder Contents


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"
  3. Install Font


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…"
  3. Start Mail Merge
    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.
  2. For example, select "Labels".
  3. Click "Next: Starting document" to move to Step 2.
  4. Select Labels


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. Label Options
  4. 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".
  6. Select Recipients


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.
  4. Insert Fields
    For example, add: Endorsement, FirstName, LastName, Address, City, State, Zip, Plus4, IMBAlphaCode
    Add Fields
  5. Once you add all your fields, click "Close".
  6. Add the spaces and separate each address line.
  7. 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.
  8. Format the Intelligent Mail Barcode by highlighting the "MD_IMBALPH" or "MD_IMBAlphaCode" field, then right-click and change font to "USPS4CB" and size to "16".
  9. Click "OK" or press Enter.
  10. «MD_IMBAlphaCode»


    Highlight MD_IMBALPH


  11. Click "Update All Labels".
  12. 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".
  5. Print
    Merge to Printer