I went to Graham Mayor's webpage and thought I followed the instructions and
here is what I got (I was trying to get the "List Price" = LST_PRICE to show
as a dollar amount). The first group are my field names and coding. The
second set of information is a sample of the result. Obviously I something
is "lost in translation." Most likely something really simple.

{«LST_PRICE» Amount \# "$, 0.00 ;( $, 0.00)"}

«CARLINE»

«STOCK_NO»

«Pinstripes»

«Paint»

«Total»



{27315. Amount \# "$, 0.00 ;( $, 0.00)"}

ACCORD COUPE

5014.0

459.

250.

28024



"Doug Robbins - Word MVP" wrote in message
...
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Just saving the mailmerge main document as a document should suffice.
Then
just open it and execute the merge whenever it is required.


--
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
"David Nelson" wrote in message
...
I am attempting to merge Excel fields into a Word Document using
mailmerge
(essentially filling in a form). For lack of a better document I am
using
"letter" merge (8.5"x11") as my "form" (e.g. a blank piece of paper). I
am
experiencing two issues:

1. The numbers are losing their formating. One field I would like to
have
as currency with cents and another is a "Stock Number" that is
alphanumeric.
The currency field comes across as a number with no formating. The
alphanumeric part is fine as long as it is numeric only (if an "alpha" is
in
it the value returned is "0"). My field values are reflected as
STOCK_NO and LST_PRICE.

2. My second issue is that this process would be run several times a
week.
It appears the easiest way to make this repeatable is to create a
template
(*.dot) file that references the same Excel file and process it with the
updates...or am I missing something?

Thanks in Advance,

Dave