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 Tools>Options>General, 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" <jimmyd[ at ]discussions.microsoft.com> wrote in message
news:BF7D6771-084E-43AA-B90F-E5DBF91AB647[ at ]microsoft.com...
[Quoted Text] > "{MERGEFIELD "Offer_Deadline" \[ at ] "MMMM d, yyyyy" }
> When this is previewed it shows 39801 as the date...
|