[Elsa G]

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?

[macropod]

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
--
macropod
[MVP - Microsoft Word]
-------------------------

"Elsa G" Elsa wrote in message ...
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?

[Graham Mayor]

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

--

Graham Mayor - Word MVP

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



macropod wrote:
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

"Elsa G" Elsa wrote in message
...
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?