Mail Merge Word 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KentGSr - 22 Jun 2007 18:24 GMT

I have created a mail merge from an Excel file and all is fine except that
one field is an "amount" which is in the Excel data base as having two digits
after the decimal point. When I merge, I get four digits after the decimal.
I have reformated the Excel calculation and formatted again to have two
digits, and it still comes out as four.

Anyone have an idea how to fix this?

Reply to this Message

Peter Jamieson - 22 Jun 2007 18:47 GMT

You probably need to use a "numeric formatting switch" in your Word Mail
Merge Main Document.

For example, if the amount column in your Excel sheet is called "myamount"
then your Mail Merge Main Document may have a field like

{ MERGEFIELD myamount }

(Use Alt-F9 to show the "field codes")

You probably need to change that to

{ MERGEFIELD myamount \#"0.00" }

Peter Jamieson

>I have created a mail merge from an Excel file and all is fine except that
> one field is an "amount" which is in the Excel data base as having two
[quoted text clipped - 5 lines]
>
> Anyone have an idea how to fix this?

Reply to this Message

KentGSr - 22 Jun 2007 19:45 GMT

Peter, Thanks for your reply but I am left a little confused.

I tried Alt F9 in two places and found no way to add the # 0.00......should
I change the column heading in my Excel data base to say "Amount/# 0.00" or
should I do it somewhere else?

I get the "amount" from the Excel file and it automatically loads it in to
the mail merge letter as <<amount>> and I cannot seem to change that to
<<amount /# 0.00>>, as I think you are suggesting.

Any ideas??

Thanks for your help

> You probably need to use a "numeric formatting switch" in your Word Mail
> Merge Main Document.
[quoted text clipped - 21 lines]
> >
> > Anyone have an idea how to fix this?

Reply to this Message

Peter Jamieson - 22 Jun 2007 20:11 GMT

In your Mail Merge Main Document, use Alt-F9 until you see something like

{ MERGEFIELD amount }

or it may look like

{ MERGEFIELD amount \*Mergeformat }

The stuff between the { } is just text, which yoiu can change on the
keyboard. So if for example you see

{ MERGEFIELD amount }

then you can click after "amount" and type

\#"0.00"

so you end up with

{ MERGEFIELD amount \#"0.00" }

then click Alt-F9 and if necessary, select the field and press F9 to update
the result.

If "\*Mergeformat" is in there, it probably won't do any harm to delete it.

Peter Jamieson

> Peter, Thanks for your reply but I am left a little confused.
>
[quoted text clipped - 39 lines]
>> >
>> > Anyone have an idea how to fix this?

Reply to this Message

KentGSr - 22 Jun 2007 20:42 GMT

Dear Peter......IT WORKED.....you have been tremendously helpful....thank you
so much.

> In your Mail Merge Main Document, use Alt-F9 until you see something like
>
[quoted text clipped - 67 lines]
> >> >
> >> > Anyone have an idea how to fix this?

Reply to this Message

Rate this thread: