| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Mailmerge from EXCEL, custom format problem
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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.803 / Virus Database: 546 - Release Date: 30/11/2004 |
|
#2
|
|||
|
|||
|
Use a formatting switch on the field - http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org TonyB wrote: 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.803 / Virus Database: 546 - Release Date: 30/11/2004 |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting custom size problem | Page Layout | |||
| Excel Paste Link - Insert row problem | Microsoft Word Help | |||
| Link to Excel (Formatting Problem) | Microsoft Word Help | |||
| Problem with mailmerge from with a rtf datasource, from access vba | Mailmerge | |||
| mail merge using excel spread looses the format for social securit | Mailmerge | |||
Linear Mode
