<<Title>> <<First>> <<Last>>
<<Company>>
<<Address>>
<<City>>, <<State>> <ZipPostal_Code>>
About half the merged addresses will show United States of America in
place
of the zip code. For example:
Mr. Ross Causey
Booz Allen & Hamilton
201 N Charles Street, Suite 1201
Baltimore, MD United States of America
Others are correct. For example:
Mr. Amos Adams
4619 Horizon Circle, Apt. 102
Pikesville, MD 21208
Both are entered correctly in Outlook.
Russ Valentine said:
I understood your problem.
Tell me what you did with my recommendation and what happened. Post your
new
merge field array.
--
Russ Valentine
[MVP-Outlook]
Karl Berger said:
If you look at my original message you will see that I have absoluteley
no
difficulty creating and using a mail merge. Your responses have never
addressesd my issue which is that the zipcode field of many records
contains
the country of the addressee. This must be an Outlook problem. It
appears
that if the zipcode contains a 5+4 zipcode then the mail merge zipcode
field
will contain the country. If the zipcode is a 5 digit code then the
zipcode
field is correct.
:
Select the Contacts to which you want to merge in Outlook.
Tools > Mail Merge. Word will launch to complete the rest of the
operation.
Your Insert Merge Field dialog in Word should now contain Outlook's
fields
in the Database fields column.
--
Russ Valentine
[MVP-Outlook]
How?
:
Start the merge from Outlook and use Outlook's fields (not Word's)
to
parse
your address.
--
Russ Valentine
[MVP-Outlook]
message
This code:
{ADDRESSBLOCK \f
"<<_TITLE0_>><<_FIRST0_>><<_LAST0_>><<_SUFFIX0_>><
<<_COMPANY_
<<_STREE1_
<<_STREET2_
<<_CITY_>><<,_STATE_>><<_POSTAL_>>" \l 1033 \c 0 \e "United
Styaes"
\d}
Produces this text:
Mr. Ross Causey
Booz Allen & Hamilton
201 N Charles Street, Suite 1201
Baltimore, MD United States of America
The Outlook entry for this record shows the zip code as
21201-4116.
What other information do you need?
:
Hard to say since you haven't told us what you are doing.
Post the exact layout of the merge fields you are using to
create
the
address.
--
Russ Valentine
[MVP-Outlook]
message
I am using Outlook 2003 with Word 2003 to make a mail merge for
envelopes.
All addresses are in the USA. I selected not to include the
country
field
in
the address block. The "Unites States of America" appears
instead
of
the
zip
code in about half the merged addresses. When I check the
address
detail
for
these addresses in Outlook they appear perfectly correct with
the
zipcode
in
the zipcode field and the country in the country field. The
appear
to
be
formatted exctly the same as addresses that are handled
correctly.
The same thing happens whether I use the Address Block or
select
individual
fields to format the envelop. Obviously Outlook is storing the
country
into
the zipcode field in half the addresses.
What am I doing wrong?