Mail Merge Formatting

[Dan M.]

I am attempting to run a mail merge to a form letter from
an Access query and it is working perfectly except for
one problem:

The numbers that are merged into the form letter come up
as decimalized numbers and not formatted numbers like in
the query. I have tried removing the "MAILMERGE" and
replaced it with "REF" like one help hint told me to do,
but that has not helped.

Does anyone know how to make sure the formatted
(currency, percentage) numbers transfer to the form
letter exactly as they appear in the query and database?

Thank you for your help!

 

[Doug Robbins - Word MVP]

Hi Dan,

Add the appropriate numeric picture switch \# "0.00%" or \# ",$#.00" inside
the closing } of the mergefield in hte mailmerge main document. Use Alt+F9
to toggle on/off the field codes.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Dan M.]

I actually figured the formatting out last night through
trial and error. Now my issue is with the percentage
feature. The original number was inputted as ".075" in
the Access database and I would like it to appear on the
form letter as 7.50% for aesthetic reason. Is there
anyway to insert a formula in word that would multiply
the original number by 100 in order to get the desired
effect? Otherwise it appears that I'll have to go in and
change each of the 175 entries in Access to make it work
and I'm trying to avoid that for now and in the future.

thanks again for your help!

 

[Doug Robbins - Word MVP]

Hi Dan,

Use the mergefield and one component of a formula field in word

{ = { MERGEFIELD Percent } * 100 \# "0.00%" }

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP