Mail Merge and Telephone Numbers

[penret]

Hi.

I have several Word mail merged documents from Access where the telephone number displays incorrectly. In a single document it displays as 1234567890 and 123-456-7890 and (123) 456-7890. Why three different styles?

I have searched here and MS help online. At the moment I have in the merge field, as suggested {MERGEFIELD TELEPHONE \ # “(###) ###’-‘####”} but it is not effective.

I tried confirm conversion at open but that did not work (if I did it correctly).

I am using Word and Access 2002.

Thank you

 

[SkipVought]

Hi,

Check your source data. Seems like that's how the data has been stored.

Skip,

_[red][/red]

 

[penret]

Hi:

The phone numbers are all from the same table and entered the same way. \(999") "999\-9999! but it is text - is this the issue? But why would there be three different styles?

Thank you for your time.