How do I make input mask from access appear in word mail merge?

[SD12345]

I am doing a mail merge in word, with data taken from an access database. In
the database, I have an input mask for the telephone numbers, but I cannot
figure out how to make that mask actually print in my word mail merge
document. The phone number is coming out like this: 8557774321. I want the
mail merge to actually print out the input mask, like it shows in the data
sheet in access, like this: (855) 777-4321

Any help is greatly appreciated!

 

[Douglas J. Steele]

When you use an Input Mask, you have the option of having Access just store
the data, or store it formatted as it appears when using the Input Mask.

Since it sounds like the data in your table isn't being stored formatted,
you'll either have to change the option associated with your Input Mask AND
update all of the existing data in your table, or create a query that uses
the Format function to format your data the way you want it to appear, and
use the query, rather than the table, when merging with Word.