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

​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  Read More

​