Software

Ask something
Discussion Locked

Word Mail Merge - Mask Field

0 helpful
9 replies

by nicholasp

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am doing a mail merge with Word 97 on an Access 97 database. I have a field which in the Access database has a mask. The number looks like 123-45-xy, but when I do the mail merge I loose the mask, how do I format it in the mail merge to have a mask?

thamks

9 replies

by dklippert

Select the Merge field and hit Alt+F9 to see the field. Add a picture formatting switch that may look like:

{ MERGEFIELD number \# "123-45-##" }

by devmann

To retain the formatting, include the \* MERGEFORMAT switch in the field code. Word includes this switch if you insert a field by using the Field command on the Insert menu and select the Preserve formatting during updates check box.

by dklippert

Word uses the "native" unmasked number for merging, so the data will have to be formatted in Word. What does the mask look like in Access?
What does the original data look like?

by nicholasp

I solved the problem by saving the mask in Access.
So the data was saved as 123-45-xy (with the dashes)
Thanks for your help.

This discussion is closed to new replies.