You skipped the important third paragraph when you took that information
from my web site
Toggle the field code (ALT+F9) to change LTST_PRICE to {Mergefield
LSTST_PRICE}
Inside the brackets, add the switch
Toggle back, then F9 to update.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
David Nelson wrote:
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