Formatting Date in Merge

[swimdad16]

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?

 

[Peter Jamieson]

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