Zipcode not correct in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karl Berger - 12 Dec 2005 21:05 GMT

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?

Reply to this Message

Russ Valentine [MVP-Outlook] - 12 Dec 2005 21:35 GMT

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.

Signature

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
[quoted text clipped - 15 lines]
>
> What am I doing wrong?

Reply to this Message

Karl Berger - 12 Dec 2005 21:52 GMT

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
[quoted text clipped - 18 lines]
> >
> > What am I doing wrong?

Reply to this Message

Russ Valentine [MVP-Outlook] - 12 Dec 2005 22:10 GMT

Start the merge from Outlook and use Outlook's fields (not Word's) to parse
your address.

Signature

Russ Valentine
[MVP-Outlook]

> This code:
>
[quoted text clipped - 43 lines]
>> >
>> > What am I doing wrong?

Reply to this Message

Karl Berger - 12 Dec 2005 22:20 GMT

How?

> Start the merge from Outlook and use Outlook's fields (not Word's) to parse
> your address.
[quoted text clipped - 45 lines]
> >> >
> >> > What am I doing wrong?

Reply to this Message

Russ Valentine [MVP-Outlook] - 12 Dec 2005 23:00 GMT

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.

Signature

Russ Valentine
[MVP-Outlook]

> How?
>
[quoted text clipped - 51 lines]
>> >> >
>> >> > What am I doing wrong?

Reply to this Message

Karl Berger - 13 Dec 2005 03:45 GMT

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.
[quoted text clipped - 55 lines]
> >> >> >
> >> >> > What am I doing wrong?

Reply to this Message