Forum Discussion

Carl_61's avatar
Carl_61
Iron Contributor
Dec 08, 2024

Mail Merge Dates Issue

I have an Excel Sheet that includes dates.  I have created a Word Mail Merge Document that includes the merging of dates and other information from the Excel Sheet. In the merge, all data other than ...
office 365
richbrooksmct's avatar
richbrooksmct
Copper Contributor
Dec 08, 2024

Excel dates are just numbers (the number of days since Dec 31, 1899)   So when you write "Date shown in Excel", the phrase is dependent upon that format you are displaying that number.

So, in Mail Merge, you can also set the number of the date in a specific format.   From a fellow MCT page, here are some examples.

 

Field Code   Displayed Results

{ MERGEFIELD Date \@ “dddd, MMMM d, yyyy” }  Saturday, July 9, 2022

{ MERGEFIELD Date \@ “MM/dd/yyyy” }  07/09/2022

{ MERGEFIELD Date \@ “M-d-yy” }  7-9-22

{ MERGEFIELD Date \@ “MMMM d, yyyy” }  July 9, 2022

https://thesoftwarepro.com/date-text-mail-merge-formatting-in-word-document/

And I just saw Han's reply.   Go with his

 

Fleetamus's avatar
Fleetamus
Copper Contributor
Feb 27, 2025

this doesn't always work. I had to create a new column with =TEXT(A1,"mm-dd-yyyy") then copy paste the values only to columns A. That provided the correct format in the mailmerge.

Resources