[Graham Mayor]

would suggest you use another fieldname for REF as REF is a reserved type
of field in Word and the names *may* cause confusion.

For your other question I would use {Mergefield Cost \# "£,0.00"} - see
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Pete Rooney wrote:
Dean,

Thanks very much for clearing this up! :-)
I just posted another one too about a problem with the position of
the £ sign in a merged currency field. Maybe you can help with that,
too? Have a good weekend
Pete

"DeanH" wrote:

That is to say the field code should be:
{MERGEFIELD Ref\#"000000"}
and after a little playing around the only space that is required is
the space between "MERGEFIELD" and "Ref" (in this case) but no
speech quotes. All the best
DeanH

"DeanH" wrote:

Try \# not \@ and yes the spaces are important I believe.
All the best
DeanH

"Pete Rooney" wrote:

Dean, Steve,

Sorry to hijack your thread, but I could do with a bit of help
with a variation on this. In my Excel database, I have a reference
number column, custom formatted to "000000", so if the reference
number is 56, it is displayed as "000056" and so on.
I want this formatting to appear in my Word mailmerge document.
Looking at your example, I thought that {MERGEFIELD
"Ref"\@"000000"} would do, but it still displays 56 instead of
000056 and so on.
Any idea what I'm doing wrong? I sometimes have a confused
keyboard that transposes the " and @ keys, but I don't think it's
that. Are the spaces important?
Cheers & thanks in advance

Pete






"DeanH" wrote:

Congratualtions.
Well done for persevering.
You are welcome.
All the best
DeanH

"Steve" wrote:

Hi Dean: I've done it at last...... rather than do the SHFT+F9 I
right clicked the mouse & went to the Edit Field option, Field
Codes then altered the code as you suggested. Thanks Dean you're
a star!!! Much appreciated

"DeanH" wrote:

Select the field, SHFT+F9 to toggle to edit mode, type in the
switch, insure you have the spaces as these seems to be
important.
Then F9 to refresh field and crossfingers.
Hope this helps
DeanH


"Steve" wrote:

Thanks DeanH,I don't want to appear thick but I'm not fully
familiar with how to get to the Mergefield to change as you
explained but I am searching. I will let you know when i've
done it. Thanks

"DeanH" wrote:

Add the date format into the merge filed coding for example
for a merge filed called Date:

{MERGEFIELD Date \@ "dd-MMM-yy"}

The caps of MMM are important, have a play.
Hope this helps
DeanH

"Steve" wrote:

I have a date field in excel which reads dd mmm yy. when I
export the mail merge into the Word document it reads mm dd
yy. I've tried changing the language to rectify this but it
hasn't worked. Any ideas on this guys please. Thanks