Mailmerge from EXCEL, custom format problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TonyB - 01 Dec 2004 14:20 GMT

I have an excel spreadsheet containing info which I want to merge into a
standard form letter. I can get it all working except for the telephone
numbers. These are displayed correctly in Excel in the 01234987654 format
used in the UK with the leading zero as required. I use a custom format in
excel to get these displayed correctly.
However when I mailmerge, the leading zero is removed ?
Any ideas how I can fix this ?
Regards
Tony

Reply to this Message

Graham Mayor - 01 Dec 2004 16:41 GMT

Use a formatting switch on the field -
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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have an excel spreadsheet containing info which I want to merge
> into a standard form letter. I can get it all working except for the
[quoted text clipped - 10 lines]
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.803 / Virus Database: 546 - Release Date: 30/11/2004

Reply to this Message