[Steve]

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

[DeanH]

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

[Steve]

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

[DeanH]

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

[Steve]

Hi Dean, found what you mentioned and I've tried what you said, this still
hasn't altered anything, what I have noticed however is that the date within
the Mail Recipients screen, (with all merged field options in) has the format
which I don't want. Is there facility to alter this?
Thanks

"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

[DeanH]

I have noticed that the Mail Recipient screen shows the incorrect format and
cannot be edited but this seems unneccary because with the Mergefield with
the Date format switch as below, after the merge the date is displayed in the
correct format.
{ MERGEFIELD Date \@ "dd-MMM-yy" }
I cannot get the error that you are experiencing.

After the merge do you still have the field present, or has the text become
"unlinked"
to a field? Can you copy the field syntax you have so I can compare.
DeanH

"Steve" wrote:

Hi Dean, found what you mentioned and I've tried what you said, this still
hasn't altered anything, what I have noticed however is that the date within
the Mail Recipients screen, (with all merged field options in) has the format
which I don't want. Is there facility to alter this?
Thanks

"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

[Steve]

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

[DeanH]

Congratulations.
Please ignore my previous/next message, superfluous now.
Glad to help.
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

[DeanH]

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

[Pete Rooney[_2_]]

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

[DeanH]

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

[DeanH]

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

[Pete Rooney[_2_]]

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

[DeanH]

If you are trying to do:
{ MERGEFIELD Cost \# £#,##.## }
and get £ ##.## when less that 1,000, I am afraid I have not been able to
figure this one out, except to have the field code as £#.## and forget about
the comma seperator.
If anyone else knows how to have this format, please post here.
I will certainly try to have a "great" weekend, you to.
DeanH

"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

[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