Zipcode not correct in mail merge

K

Karl Berger

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?
 
R

Russ Valentine [MVP-Outlook]

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.
 
K

Karl Berger

This code:


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?

Russ Valentine said:
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]
Karl Berger said:
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?
 
R

Russ Valentine [MVP-Outlook]

Start the merge from Outlook and use Outlook's fields (not Word's) to parse
your address.
--
Russ Valentine
[MVP-Outlook]
Karl Berger said:
This code:


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?

Russ Valentine said:
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]
Karl Berger said:
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?
 
K

Karl Berger

How?

Russ Valentine said:
Start the merge from Outlook and use Outlook's fields (not Word's) to parse
your address.
--
Russ Valentine
[MVP-Outlook]
Karl Berger said:
This code:

{ADDRESSBLOCK \f said:
<<_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?

Russ Valentine said:
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]
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?
 
R

Russ Valentine [MVP-Outlook]

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]
Karl Berger said:
How?

Russ Valentine said:
Start the merge from Outlook and use Outlook's fields (not Word's) to
parse
your address.
--
Russ Valentine
[MVP-Outlook]
Karl Berger said:
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]
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?
 
K

Karl Berger

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.

Russ Valentine said:
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]
Karl Berger said:
How?

Russ Valentine said:
Start the merge from Outlook and use Outlook's fields (not Word's) to
parse
your address.
--
Russ Valentine
[MVP-Outlook]
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]
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?
 
R

Russ Valentine [MVP-Outlook]

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.

Russ Valentine said:
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]
Karl Berger said:
How?

:

Start the merge from Outlook and use Outlook's fields (not Word's) to
parse
your address.
--
Russ Valentine
[MVP-Outlook]
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?
 
K

Karl Berger

<<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.

Russ Valentine said:
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]
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?
 
R

Russ Valentine [MVP-Outlook]

Very strange. That looks exactly right to me and works perfectly here. I
cannot reproduce the behavior you are seeing. Were any of these Contacts
ever imported? If you look at a Contact that isn't displaying correctly, are
you sure each of the individual address elements is parsed correctly?
I suspect something may be wrong with your PST file. Have you checked it for
errors?
I have seen some instances where having the Country/Region field populated
disrupts Word's Insert Address Feature, but I've never seen it disrupt a
mail merge from Outlook like this. Maybe someone else has.
--
Russ Valentine
[MVP-Outlook]
Karl Berger said:
<<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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top