![]() |
|
#2
|
||||
|
||||
|
Your description suggests some of the phone numbers have been input into the Excel workbook with the hyphens, whilst others have not. Consequently, you have a mix of numeric and non-numeric data. That, in turn causes the mailmerge to read the non-numeric data as formulae (i.e. the second part of the phone # gets subtracted from the first part). The solution is to remove all the hyphens in Excel.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
can you change department field in phone numbers
|
pspec | Outlook | 2 | 04-05-2014 02:51 AM |
Extracting a phone number from a string that contains text and numbers.
|
hommi16 | Excel | 2 | 06-05-2013 09:19 PM |
| Converting Phone Numbers Question | certified_techy | Excel | 8 | 06-08-2012 02:27 AM |
| Create Custom Labels for Phone numbers | Tonistep | Outlook | 0 | 03-26-2012 02:57 PM |
Continuous page numbers with mail merge?
|
Jennifer Murphy | Mail Merge | 1 | 08-11-2011 05:27 AM |