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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Douglas said:
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.
Click to expand...

To add to that, I believe you can do some formatting in Word as well.
 
Back
Top