Mail Merge Formatting

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
Mon Oct 13 21:29:42 CDT 2003

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." <danmats@tcinternet.net> wrote in message
news:187001c391ef$d9168990$a001280a@phx.gbl...
> 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!

Dan
Tue Oct 14 07:57:38 CDT 2003

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!
>-----Original Message-----
>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." <danmats@tcinternet.net> wrote in message
>news:187001c391ef$d9168990$a001280a@phx.gbl...
>> 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
Tue Oct 14 18:22:56 CDT 2003

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
"Dan M." <danmats@tcinternet.net> wrote in message
news:0e2b01c39252$bec6f7b0$a401280a@phx.gbl...
> 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!
> >-----Original Message-----
> >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." <danmats@tcinternet.net> wrote in message
> >news:187001c391ef$d9168990$a001280a@phx.gbl...
> >> 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!
> >
> >
> >.
> >