export access as a merge doc.

E

Elisabeth

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Width of document changes when merging 1
How to export html text as word document with specific size and orientation 0
You don't currently have permission to access this folder 0
Excel --> Word 4
VBA - exporting serial letters to single documents 0
Page numbering with Merged Document and IF statements 1
Word doc keeps changing to ALL CAPS 0
Merging from an Excel file with graphics 1

Top