Mailmerge numbering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keelin - 06 Jul 2005 19:09 GMT

How do I set up a mailmerge with Excel 2003 so that my numeric field (which
is set up from 00001-00015) comes into Word without suppressing the leading
zeros? Currently I am using custom formatting to automatically add the
leading zeros. However, when I merge the Excel document the numbers appear in
Word without the leading zeros.

Reply to this Message

Anne Troy - 06 Jul 2005 21:12 GMT

See the example for zipcodes.
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> How do I set up a mailmerge with Excel 2003 so that my numeric field (which
> is set up from 00001-00015) comes into Word without suppressing the leading
> zeros? Currently I am using custom formatting to automatically add the
> leading zeros. However, when I merge the Excel document the numbers appear in
> Word without the leading zeros.

Reply to this Message

Graham Mayor - 07 Jul 2005 05:16 GMT

You need a formatting switch specifically \# "00000"
See http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> How do I set up a mailmerge with Excel 2003 so that my numeric field
> (which is set up from 00001-00015) comes into Word without
> suppressing the leading zeros? Currently I am using custom formatting
> to automatically add the leading zeros. However, when I merge the
> Excel document the numbers appear in Word without the leading zeros.

Reply to this Message