A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Zipcode not correct in mail merge



 
 
Thread Tools Display Modes
  #1  
Old December 12th, 2005, 10:05 PM posted to microsoft.public.outlook.contacts
external usenet poster
 
Posts: n/a
Default Zipcode not correct in mail merge

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?
  #2  
Old December 12th, 2005, 10:35 PM posted to microsoft.public.outlook.contacts
external usenet poster
 
Posts: n/a
Default Zipcode not correct in mail merge

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" wrote in 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?



  #3  
Old December 12th, 2005, 10:52 PM posted to microsoft.public.outlook.contacts
external usenet poster
 
Posts: n/a
Default Zipcode not correct in mail merge

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?

"Russ Valentine [MVP-Outlook]" wrote:

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" wrote in 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?




  #4  
Old December 12th, 2005, 11:10 PM posted to microsoft.public.outlook.contacts
external usenet poster
 
Posts: n/a
Default Zipcode not correct in mail merge

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

"Russ Valentine [MVP-Outlook]" wrote:

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" wrote in 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?






  #5  
Old December 12th, 2005, 11:20 PM posted to microsoft.public.outlook.contacts
external usenet poster
 
Posts: n/a
Default Zipcode not correct in mail merge

How?

"Russ Valentine [MVP-Outlook]" wrote:

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

"Russ Valentine [MVP-Outlook]" wrote:

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" wrote in 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?






  #6  
Old December 13th, 2005, 12:00 AM posted to microsoft.public.outlook.contacts
external usenet poster
 
Posts: n/a
Default Zipcode not correct in mail merge

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" wrote in message
...
How?

"Russ Valentine [MVP-Outlook]" wrote:

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

"Russ Valentine [MVP-Outlook]" wrote:

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" wrote in 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?








  #7  
Old December 13th, 2005, 04:45 AM posted to microsoft.public.outlook.contacts
external usenet poster
 
Posts: n/a
Default Zipcode not correct in mail merge

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 [MVP-Outlook]" wrote:

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" wrote in message
...
How?

"Russ Valentine [MVP-Outlook]" wrote:

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

"Russ Valentine [MVP-Outlook]" wrote:

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" wrote in 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?









  #8  
Old December 13th, 2005, 10:57 AM posted to microsoft.public.outlook.contacts
external usenet poster
 
Posts: n/a
Default Zipcode not correct in mail merge

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" wrote in message
...
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 [MVP-Outlook]" wrote:

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" wrote in message
...
How?

"Russ Valentine [MVP-Outlook]" wrote:

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

"Russ Valentine [MVP-Outlook]" wrote:

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" wrote in
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?











  #9  
Old December 13th, 2005, 03:59 PM posted to microsoft.public.outlook.contacts
external usenet poster
 
Posts: n/a
Default Zipcode not correct in mail merge

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 [MVP-Outlook]" wrote:

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" wrote in message
...
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 [MVP-Outlook]" wrote:

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" wrote in message
...
How?

"Russ Valentine [MVP-Outlook]" wrote:

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

"Russ Valentine [MVP-Outlook]" wrote:

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" wrote in
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?












  #10  
Old December 13th, 2005, 10:45 PM posted to microsoft.public.outlook.contacts
external usenet poster
 
Posts: n/a
Default Zipcode not correct in mail merge

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" wrote in message
...
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 [MVP-Outlook]" wrote:

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" wrote in message
...
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 [MVP-Outlook]" wrote:

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" wrote in message
...
How?

"Russ Valentine [MVP-Outlook]" wrote:

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

"Russ Valentine [MVP-Outlook]" wrote:

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" wrote in
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?














 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
only one page of mail merge document is printing dkilventon General Discussion 0 November 22nd, 2005 07:15 PM
Why aren't my contacts correct in mail merge from Outlook? & other jviren Contacts 2 August 23rd, 2005 11:37 AM
Word-Excel 2003 - Mail Merge Recipients problem Gabbi Mailmerge 4 January 11th, 2005 05:11 AM
Mail merge conversion from Word to .NET code. mutton Mailmerge 1 November 17th, 2004 03:09 AM
Mail Merge Problem MT DOJ Help Desk General Discussion 9 July 20th, 2004 04:55 AM


All times are GMT +1. The time now is 01:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.