Mailers Online:Print Labels - Revision history

Admin at 00:48, 29 April 2023

2023-04-29T00:48:38Z

← Older revision		Revision as of 00:48, 29 April 2023
Line 32:		Line 32:

	<ol>		<ol>
	<li>Open the extracted folder and double-click on the file usps4cb.ttf to open the USPS Fonts.</li>		<li>Open the extracted folder and double-click on the file "'''usps4cb.ttf'''" to open the USPS Fonts.</li>
	<li>Click "Install"</li>		<li>Click "'''Install'''"</li>


Line 41:		Line 41:

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

	<ol>		<ol>
	<li>Click the "Mailings" tab.</li>		<li>Click the "'''Mailings'''" tab.</li>
	<li>Click the "Start Mail Merge" drop-down and select "Step-by-Step Mail Merge Wizard…"</li>		<li>Click the "'''Start Mail Merge'''" drop-down and select "'''Step-by-Step Mail Merge Wizard…'''"</li>


Line 58:		Line 58:
	<ol>		<ol>
	<li>Choose the type of document you want to create.</li>		<li>Choose the type of document you want to create.</li>
	:For example, select "Labels"		:For example, select "'''Labels'''".
	<li>Click Next: Starting document to move to Step 2.</li>		<li>Click "'''Next: Starting document'''" to move to Step 2.</li>


Line 72:		Line 72:
	For example:		For example:

	<li>Click "Label options" and select the labels that you purchased.</li>		<li>Click "'''Label options'''" and select the labels that you purchased.</li>
	<li>Select "Avery® US Letter – 15661 Easy Peel Address Labels" (Make sure the label you use is at least 1 inch x 3.5 inches.).</li>		<li>Select "'''Avery® US Letter – 15661 Easy Peel Address Labels'''" (Make sure the label you use is at least 1 inch x 3.5 inches.).</li>


Line 79:		Line 79:


	<li>Click "Next: Select recipients to move to Step 3".</li>		<li>Click "'''Next: Select recipients to move to Step 3'''".</li>
	</ol>		</ol>

Line 85:		Line 85:
	<h3 class="productfield">Step 3 - Select Recipients</h3>		<h3 class="productfield">Step 3 - Select Recipients</h3>
	<ol>		<ol>
	<li>Select "Use an existing List"</li>		<li>Select "'''Use an existing List'''"</li>
	<li>Click "Browse".</li>		<li>Click "'''Browse'''".</li>
	<li>Open the Results file from the recently extracted Mailers Online folder.</li>		<li>Open the Results file from the recently extracted Mailers Online folder.</li>
	<li>Click "OK".</li>		<li>Click "'''OK'''".</li>
	<li>Click "Next: Arrange Your Labels".</li>		<li>Click "'''Next: Arrange Your Labels'''".</li>


Line 98:		Line 98:
	<h3 class="productfield">Step 4 - Add Database Fields and Format Barcode</h3>		<h3 class="productfield">Step 4 - Add Database Fields and Format Barcode</h3>
	<ol>		<ol>
	<li>Add Database Fields by selecting "More Items" under "Arrange your Labels".</li>		<li>Add Database Fields by selecting "'''More Items'''" under ''Arrange your Labels''.</li>
	<li>Select Insert: "Database Fields".</li>		<li>Select Insert: "'''Database Fields'''".</li>
	<li>Add each Field needed for Labels, in order. Spacing can be adjusted after the desired fields are added.</li>		<li>Add each Field needed for Labels, in order. Spacing can be adjusted after the desired fields are added.</li>

Line 106:		Line 106:


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

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

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

	<li>Once you add all your fields, click "Close".</li>		<li>Once you add all your fields, click "'''Close'''".</li>
	<li>Add the spaces and separate each address line.</li>		<li>Add the spaces and separate each address line.</li>

Line 137:		Line 135:
	*If mail piece weighs more than 3 ounces, the barcode must be included in the Address Block.		*If mail piece weighs more than 3 ounces, the barcode must be included in the Address Block.

	<li>Format the Intelligent Mail Barcode by highlighting the MD_IMBALPH field and change ~~the~~ font to USPS4CB~~.</li>~~		<li>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'''".</li>
	~~<li>Highlight the MD_IMBAlphaCode field and right click, then select font and choose usps4cb~~ and size 16.</li>		<li>Click "'''OK'''" or press Enter.</li>
	<li>Click "OK" or press Enter.</li>

	<pre class="indent">«MD_IMBAlphaCode»</pre>		<pre class="indent">«MD_IMBAlphaCode»</pre>
Line 147:		Line 144:


	<li>Click "Update All Labels".</li>		<li>Click "'''Update All Labels'''".</li>
	<li>Click "Next: Complete the Merge".</li>		<li>Click "'''Next: Complete the Merge'''".</li>
	</ol>		</ol>

Line 156:		Line 153:
	For example:		For example:

	<li>Click "Print".</li>		<li>Click "'''Print'''".</li>
	<li>Select Print Records: "All" options and click "OK".</li>		<li>Select Print Records: "'''All'''" options and click "'''OK'''".</li>
	<li>Select Printer Name: "Microsoft Print to PDF" and click "OK".</li>		<li>Select Printer Name: "'''Microsoft Print to PDF'''" and click "'''OK'''".</li>
	<li>Enter File Name to save as and click "Save".</li>		<li>Enter File Name to save as and click "'''Save'''".</li>

Admin at 00:32, 14 April 2023

2023-04-14T00:32:47Z

← Older revision		Revision as of 00:32, 14 April 2023
Line 154:		Line 154:
	<h3 class="productfield">Step 5 - Complete the Merge & Print Labels</h3>		<h3 class="productfield">Step 5 - Complete the Merge & Print Labels</h3>
	<ol>		<ol>
	:For example,		For example:

	<li>Click "Print".</li>		<li>Click "Print".</li>

Admin at 00:32, 14 April 2023

2023-04-14T00:32:01Z

← Older revision		Revision as of 00:32, 14 April 2023
Line 69:		Line 69:
	<ol>		<ol>
	Choose how you want to set up your mailing labels.		Choose how you want to set up your mailing labels.

	For example:		For example:

	<li>Click "Label options" and select the labels that you purchased.</li>		<li>Click "Label options" and select the labels that you purchased.</li>
	<li>Select "Avery® US Letter – 15661 Easy Peel Address Labels" (Make sure the label you use is at least 1 inch x 3.5 inches.).</li>		<li>Select "Avery® US Letter – 15661 Easy Peel Address Labels" (Make sure the label you use is at least 1 inch x 3.5 inches.).</li>
Line 101:		Line 103:


	:[[File:MO_Print_09-AddFields.png\|900px\|alt=Insert Fields\|link=]]		:[[File:MO_Print_09-AddFields.png\|900px\|alt=Insert Fields\|link=]]</br>


			For example:

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

Line 130:		Line 133:


	:An Intelligent Mail barcode is required to claim automation prices.		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.		*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.		*If mail piece weighs more than 3 ounces, the barcode must be included in the Address Block.

			<li>Format the Intelligent Mail Barcode by highlighting the MD_IMBALPH field and change the font to USPS4CB.</li>
			<li>Highlight the MD_IMBAlphaCode field and right click, then select font and choose usps4cb and size 16.</li>
			<li>Click "OK" or press Enter.</li>

	~~:Format the Intelligent Mail Barcode by highlighting the MD_IMBALPH field and change the font to USPS4CB.~~		<pre class="indent">«MD_IMBAlphaCode»</pre>
	~~:Highlight the MD_IMBAlphaCode field and right click, then select font and choose usps4cb and size 16.~~
	~~:Click~~ "OK" ~~or press Enter.~~

	~~<pre~~>«MD_IMBAlphaCode»</pre>


Line 145:		Line 147:


	:Click "Update All Labels"		<li>Click "Update All Labels".</li>
	:Click "Next: Complete the Merge"		<li>Click "Next: Complete the Merge".</li>
			</ol>

Admin at 00:28, 14 April 2023

2023-04-14T00:28:26Z

← Older revision		Revision as of 00:28, 14 April 2023
Line 68:		Line 68:
	<h3 class="productfield">Step 2 - Select Starting Document</h3>		<h3 class="productfield">Step 2 - Select Starting Document</h3>
	<ol>		<ol>
	:Choose how you want to set up your mailing labels.		Choose how you want to set up your mailing labels.
	::For example:		For example:
	<li>Click "Label options" and select the labels that you purchased.</li>		<li>Click "Label options" and select the labels that you purchased.</li>
	<li>Select "Avery® US Letter – 15661 Easy Peel Address Labels" (Make sure the label you use is at least 1 inch x 3.5 inches.).</li>		<li>Select "Avery® US Letter – 15661 Easy Peel Address Labels" (Make sure the label you use is at least 1 inch x 3.5 inches.).</li>
Line 104:		Line 104:


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


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

			<li>Once you add all your fields, click "Close".</li>
			<li>Add the spaces and separate each address line.</li>

	~~:Once you add all your fields, click "Close" .~~		Example 1:
	~~:Add the spaces and separate each address line.~~		<pre class="indent">

	:Example 1:

	<pre>
	«MD_IMBAlphaCode»		«MD_IMBAlphaCode»
	«MD_Endorsement»		«MD_Endorsement»
Line 124:		Line 121:
	</pre>		</pre>

	:Example 2:		Example 2:
	<pre>		<pre class="indent">
	«MD_IMBAlphaCode»		«MD_IMBAlphaCode»
	«MD_NameFirst» «MD_NameLast»		«MD_NameFirst» «MD_NameLast»

Admin at 00:51, 13 April 2023

2023-04-13T00:51:21Z

Show changes

Admin at 00:44, 13 April 2023

2023-04-13T00:44:52Z

← Older revision		Revision as of 00:44, 13 April 2023
Line 2:		Line 2:
	{{CustomTOC}}		{{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.		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:		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).

	~~Create a Mailing Label.~~

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



	==Before You Begin==		==Before You Begin==
	<h3 class="productfield">Download & Extract Presorted File</h3>		<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.		<ol>
			<li>Once the Mailers Online file is purchased, it can be downloaded directly from the Mailers Online - Dashboard.</li>
			<li>Click "'''Report'''" and select "'''Download'''" in the bottom-right section of the page.</li>

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

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

	~~:[[File:MO_Print_01~~-~~Download~~.~~png\|500px\|alt=Download Button\|link=]]~~		<li>Right-click the ZIP folder and select "'''Extract All'''".</li>
			<li>Extract your file from the the downloaded file. </li></br>

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

	:Extract ~~your file from the the downloaded file~~.		::[[File:MO_Print_02-Extract.png\|300px\|alt=Extract File\|link=]]

			::[[File:MO_Print_03-Extracted.png\|800px\|alt=Folder Contents\|link=]]
	~~:[[File~~:~~MO_Print_02-Extract.png\|300px\|alt=Extract File\|link=]]~~		</ol>


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


	<h3 class="productfield">Install USPS Font</h3>		<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.		: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"		<ol>
			<li>Open the extracted folder and double-click on the file usps4cb.ttf to open the USPS Fonts.</li>
			<li>Click "Install"</li>


	:[[File:MO_Print_04-FontInstall.png\|800px\|alt=Install Font\|link=]]		:[[File:MO_Print_04-FontInstall.png\|800px\|alt=Install Font\|link=]]
			</ol>


Line 122:		Line 115:


	:[[File:MO_Print_010-Example.png\|~~500px~~\|alt=Add Fields\|link=]]		:[[File:MO_Print_010-Example.png\|350px\|alt=Add Fields\|link=]]

Admin at 00:36, 13 April 2023

2023-04-13T00:36:48Z

← Older revision		Revision as of 00:36, 13 April 2023
Line 23:		Line 23:


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

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


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


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


Line 44:		Line 44:


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


Line 57:		Line 57:


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


Line 71:		Line 71:


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


Line 84:		Line 84:


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


Line 103:		Line 103:


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


Line 114:		Line 114:


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


Line 122:		Line 122:


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


Line 173:		Line 173:


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


Line 184:		Line 184:
	For example,		For example,

	Click "Print"		Click "Print"

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


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

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


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

	:*
	*;

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


	[[Category:Mailers Online]]		[[Category:Mailers Online]]

Admin: Created page with "← 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==

Download & Extract Presorted File<..."

2023-04-13T00:35:01Z

Created page with "← 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<..."

New page

[[Mailers Online|← 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]]