I am merging from an Excel File into a Word Document.

Everything works except for a date field. I have it formatted as MM/DD/YY in
Excel but the merge displays it as YYYY-MM-DD HH:MM:SS

What do I need to do to display MM/DD/YY in the merge?

In your mail merge main document, use Alt-F9 to display the field codes and
modify, e.g.

{ MERGEFIELD myfield \*Mergeformat }

to

{ MERGEFIELD myfield \@"MM/DD/YY" \*Mergeformat }

Peter Jamieson

"swimdad16" wrote in message
.. .
I am merging from an Excel File into a Word Document.

Everything works except for a date field. I have it formatted as MM/DD/YY
in Excel but the merge displays it as YYYY-MM-DD HH:MM:SS

What do I need to do to display MM/DD/YY in the merge?