Forum Discussion
Mail Merge and Excel
Hello everyone, I could really use some insight here. I am pulling out my hair as I cannot figure out what is going on. I have rows of records from which I am trying to merge some of the info into Mail Merge. The normal data does not seem to be a problem. However, when I try to merge in Dates this is where the trouble begins. In my Mail Merge Letter I have Merge Fields that have From and To Dates that I am trying to merge in but I keep getting numbers that represent the dates. Especially the To Date and some other dates I have in the letter. Only the From Date is displaying correctly. So, as an example, I have: Monday, March 18, 2024 to 45375 when it should display as Sunday, March 24, 2024. I have applied the switches and yet I still keep getting the numbers. The date for the To Date in the Excel workbook is calculated if this makes any difference. =IF(M2="","",M2+6). Can anyone help me figure this out? I really need to perform these Mail Merges but these numbers being generated will mean nothing to no one. Seems like such a simple process yet being so complicated.
Here is the Merge field set up but regardless of this it is just showing the numbers on the merge/preview. {MERGEFIELD End_Date \@ "dddd, MMMM d, yyyy" }. What am I missing??
Thank you to any folks that can help me figure this out.
Carl
13 Replies
Carl_61 Does the first answer in this thread help? https://stackoverflow.com/questions/60357563/date-format-mail-merge-word-excel
- I wish it did. For some reason my End Date, which a calculated date in Excel, in its own cell, just keeps being returned as numbers. I even change the End Date, to see what would happen, to a hard date(not calculated, but I still get the numbers, not the date. I am super puzzled!
- Is there any row in the data sent to Word that has data that isn't a date, deviates from that date format, or perhaps is empty?
I wish it did. For some reason my
