URGENT: merging excel files into word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elsa G - 15 Apr 2008 15:24 GMT

I'm merging a word document using a database in excel. It has some dates that
were typed as April 30, 2008, however, when I do the merge, the dates show as
4/30/08. How can I fix this?

Reply to this Message

macropod - 15 Apr 2008 15:45 GMT

Hi Elsa,

You need to add a date switch.
With the date mergefield, press Shift-F9 to reveal the code, which should look something like {MERGEFIELD Date}.
Add \@ "MM dd, yyyy" to the field so that you get {MERGEFIELD Date \@ "MM dd, yyyy"}.
Press F9 to update the field.

Then re-run your mailmerge.

Cheers

Signature

macropod
[MVP - Microsoft Word]
-------------------------

> I'm merging a word document using a database in excel. It has some dates that
> were typed as April 30, 2008, however, when I do the merge, the dates show as
> 4/30/08. How can I fix this?

Reply to this Message

Graham Mayor - 16 Apr 2008 06:28 GMT

{MERGEFIELD Date \@ "MMMM dd, yyyy"} or
{MERGEFIELD Date \@ "MMMM d, yyyy"}
would be closer to the original?

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Hi Elsa,
>
[quoted text clipped - 11 lines]
>> dates that were typed as April 30, 2008, however, when I do the
>> merge, the dates show as 4/30/08. How can I fix this?

Reply to this Message