Mail Merge Excel to Word

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Congratulations.
Please ignore my previous/next message, superfluous now.
Glad to help.
All the best
DeanH

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>