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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"SD12345" <(E-Mail Removed)> wrote in message
news:47D15594-C310-45FB-82C5-(E-Mail Removed)...
>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 wrote:
> 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.

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

>
>
> "SD12345" <(E-Mail Removed)> wrote in message
> news:47D15594-C310-45FB-82C5-(E-Mail Removed)...
>>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!

--
Joseph Meehan

Dia duit