Phone Number Format problem with Mail Merge

[Brando]

Twilight Zone Phormat Problem

I have a mail merge from Access into Word that works great except for a baffling problem with phone number formatting. Instead of (987) 654-3210, on certain records the merge produces 9876543210. I cannot identify a pattern to explain it, but it is not random. Certain records consistently leave the format behind on the phone number, some on the fax number, and some on both. This problem is affecting about 1/3 of the contact records. I have the Input Mask on Phone and Fax in the table set to !\(999") "000\-0000;0;_. Is anyone familiar with this problem?

 

[WrHn85]

Hi,

We had a similar problem in our Access/Word merge docs with phone/fax numbers and also Canadian postal codes losing their spaces (that one I still haven't found a workaround for).

It's pretty easy to correct using MS Word switches in the formatting behind the field codes.
http://office.microsoft.com/en-au/assistance/HA011164951033.aspx

gives you a bit of a start and if you Google you'll find all the solutions pretty quickly.

Hope it helps.