Hello,



I have a mail merge document which pulls multiple dates. The mail merge formula is: MERGEFIELD Vest_Date_1\@ "MMMM dd, yyyy"

First three dates comes out in correct format January 01, 2017, however the other dates pulls as random number. What I am doing wrong?

My data runs up to Vest_Date_25, meaning I have 25 Dates and only first 3 dates are coming in right format. Excel data is currently set to date "01/01/2017.

Please help me, I need to send these letters out today.

That suggests most of your dates have been input as text, not as dates. Perhaps there is a space character before the date, for example.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

@macfopod: for reason I dont know, but when i changed the header for the column the date merge worked.