E Elisabeth Aug 10, 2004 #1 I have a word document that I am exporting to, but the phone numbers keep appearing without the dashes. how do I fix this?
I have a word document that I am exporting to, but the phone numbers keep appearing without the dashes. how do I fix this?
J Jim/Chris Aug 11, 2004 #3 Add a new field in your query. It should look something like this. Use yhis in your word merge NewPhone: "(" & Left([homephone],3) & ") " & Mid([homephone],4,3) & "-" & Right([homephone],4) Jim
Add a new field in your query. It should look something like this. Use yhis in your word merge NewPhone: "(" & Left([homephone],3) & ") " & Mid([homephone],4,3) & "-" & Right([homephone],4) Jim
