How to Add Postage Using Mail Merge in Microsoft Word 2003 and Excel 2003
To conduct a mail merge with postage in Microsoft Word 2003, follow these easy steps:
-
Create Recipient Address List (using Microsoft Excel)
-
In an Excel document, create a table and set up the following data headers:
<FirstName>, <LastName>, <Company>, <Address1>, <City>, <State> and <PostalCode>.
-
Add recipient address information to the appropriate columns as shown below.
|
FirstName |
LastName |
Company |
Address1 |
City |
State |
PostalCode |
|
John |
Smith |
ABC Corp |
123 1st St |
Anytown |
CA |
90000 |
|
Jane |
Doe |
-- |
456 1st St |
Anytown |
CA |
90001 |
-
If you would like to view a sample document,
download the 'sample.xls' spreadsheet.
We will be using this spreadsheet later.
-
Next, open Microsoft Word and go to Tools -> Letters and Mailings -> Mail
Merge. The mail merge toolbar will appear to the right of your screen.
-
Choose 'Envelopes' as your document type and click 'Next: Starting Document'
at the bottom of the mail merge toolbar (shown in screenshot below).
-
Select the option to 'Change document layout' from the mail merge toolbar
and click on the link called 'Envelope options...'
-
If necessary, change the envelope options so that they match your envelope
size. For this example we will use a #10 (Business) size envelope.
-
Once you have changed the envelope options, click 'OK'. This will change
the layout of your Word document to resemble an envelope. Now, click on 'Next:
Select Recipients' from the mail merge toolbar.
-
Click on 'Use an existing list' and click on 'Browse' to locate the document
that you created in Step 1. You will get a menu called 'Select Table'. Click
'OK' to continue.
-
The table will appear on your screen as shown below. Click 'OK' to accept
and close the table.
-
Back in the mail merge toolbar, click 'Next: Arrange your envelope'. Click
on your envelope in the area that normally contains your recipient's address.
This will outline around this area. See image below:
In your Mail merge toolbar, click on the link labeled 'Address block...',
this will bring up the 'Insert Address block' window.
We will leave the default options and click 'OK' to continue.
-
Next, click on the link labeled 'Electronic Postage'. This will bring up
your Stamps.com password prompt. Enter your password and click on 'Connect'.
Once connected, you should have a 'VOID Sample' indicium image on the top-right
hand corner of your envelope. See sample below:
NOTE: If you are experiencing problems connecting,
please visit the 'Troubleshooting' portion of our website at
http://www.stamps.com/support/
-
After you have finished inserting the fields, click 'Next: preview your
letters'. You will now see the first address recipient from your table merged
into your letter. You can use the << to go backward and >> to go
forward when viewing your recipients.
-
Once you have completed previewing your letters, click on the 'Next: Complete
the merge' link in the mail merge toolbar.
-
Use the 'Print...' link in the mail merge toolbar to bring up the 'Merge
to Printer' window. For this example, click on the 'All' option, then click
'OK'.
-
Select the printer that you want to print to in the 'Print' dialog box and
click 'OK'.
-
Your addresses will now be verified using the Stamps.com software. When
this has completed, click on the 'OK' button.
-
Congratulations! You have reached the final step. Simply click on the 'Print'
button to finalize your mail merge!
If the solution(s) provided in this page failed to solve your issue, please use our search form or return to our Support Home Page or contact Customer Support.
|