Mail Merge drops 1st digit ("0") converting from Excel to Word
 

I am running XP Professional - Office 2003 on a Dell Destop System

When converting an Excel file to a mail merge in Word the "zip code" column
(formatted as such), drops the first digit whenever that digit is a zero,
causing the zip code to now be invalid in the merge. (Side note: If the
first didgit is anything other other than a zero it tranfers... it is only
when the first digit is a zero that I have the difficulty.)

Is there a fix for this.

Mail Merge drops 1st digit ("0") converting from Excel to Word
 

In your merge letter you need to add a formatting switch to the zip code
field, as Word is probably viewing the all numeric field as a numeric value.
The switch would look like this sans quotes:

\#00000

In Word click on help and type the following, sans quotes, to learn how to
apply merge format switches:

Merge Format switches

Hope this helps
--
Kevin Backmann


"Chuck Martini" wrote:

I am running XP Professional - Office 2003 on a Dell Destop System

When converting an Excel file to a mail merge in Word the "zip code" column
(formatted as such), drops the first digit whenever that digit is a zero,
causing the zip code to now be invalid in the merge. (Side note: If the
first didgit is anything other other than a zero it tranfers... it is only
when the first digit is a zero that I have the difficulty.)

Is there a fix for this.

Mail Merge drops 1st digit ("0") converting from Excel to Word
 

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx


Chuck Martini wrote:
I am running XP Professional - Office 2003 on a Dell Destop System

When converting an Excel file to a mail merge in Word the "zip code" column
(formatted as such), drops the first digit whenever that digit is a zero,
causing the zip code to now be invalid in the merge. (Side note: If the
first didgit is anything other other than a zero it tranfers... it is only
when the first digit is a zero that I have the difficulty.)

Is there a fix for this.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Mail Merge drops 1st digit ("0") converting from Excel to Word
 

Try leading the entry of the Zip Code (that begins with "0") with an
apostrophe, i.e., '00210. This should tell Excel it's not a number and then
transfer it proper to Word in the merge.

P.
--
Overcome Sales Barriers
http://salesbarriers.typepad.com/


"Debra Dalgleish" wrote:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx


Chuck Martini wrote:
I am running XP Professional - Office 2003 on a Dell Destop System

When converting an Excel file to a mail merge in Word the "zip code" column
(formatted as such), drops the first digit whenever that digit is a zero,
causing the zip code to now be invalid in the merge. (Side note: If the
first didgit is anything other other than a zero it tranfers... it is only
when the first digit is a zero that I have the difficulty.)

Is there a fix for this.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html