Mail Merge bringing over wrong format on Date - Word/Excel 2013

Trying to do a mail merge in Word 2013.  The dates in excel are formatted to read as August 3, 2015.  But they come over as 8-3-2015.  How can I fix this? I get an error message when trying to open with DDE. 
Answer
Answer

Right-click the mail merge field in Word and select Toggle Field Codes from the context menu.

You should see something like

{ MERGEFIELD MyDate }

or

{ MERGEFIELD MyDate \* MERGEFORMAT }

where MyDate is the name of the date column in Excel. Change it to

{ MERGEFIELD MyDate \@ "MMMM d, yyyy" }

Press F9 to hide the field code and to update the result.

---
Kind regards, HansV
https://www.eileenslounge.com

50 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 4, 2021 Views 13,534 Applies to: