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 ...
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?
- What makes this odd then is that the begin dates for all the occupied rooms are merging correctly. It’s just the end dates, calculated based on the begin date, that just keep showing up as numbers. I’ve tried changing the Format and everything I know.
I wish it did. For some reason my
