View Single Post
 
Old 05-18-2011, 04:46 AM
rekcots rekcots is offline Windows 2K Office 2003
Novice
 
Join Date: May 2011
Posts: 2
rekcots is on a distinguished road
Default Mail merge number fields outputting inconsistently

Hello

I'm trying to complete an email mail merge where some of the fields have telephone numbers in. The data source is an Excel spreadsheet.

I've formatted the telephone merge fields in the following format \# "0000 000 0000". The telephone numbers output correctly for some of the telephone numbers but not for all the records. For example some output as 0000 000 4642 which is incorrect.

The phone numbers are all in the same format in the Excel spreadsheet I am using. Does anyone have any suggestions as to how I can correct this?

Thanks
R
Reply With Quote