[JimmyD]

"{MERGEFIELD "Offer_Deadline" \@ "MMMM d, yyyyy" }
When this is previewed it shows 39801 as the date...

[Doug Robbins - Word MVP]

If you execute the merge to a new document, is the date formatted correctly.
In the preview of a mail merge, the formatting switch may not be
implemented.

Via ToolsOptionsGeneral, check the box for "Confirm file format on open"
and when you attach the data source to the mail merge main document, try
the DDE method of connection.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"jimmyd" wrote in message
...
"{MERGEFIELD "Offer_Deadline" \@ "MMMM d, yyyyy" }
When this is previewed it shows 39801 as the date...