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 ...
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.
- Can you share an anonimized copy of both the Excel file and the mail-merge doc?
I shared my files per your request and hoping you can tell about or help me with, this albatross of a mail merge. I just don’t get it. If I have to call Microsoft directly would you know the best number to call?
- Yes, some cells in the column are empty. This list is a room roster whereby some rooms are empty so no begin date or end dates are in those cells along the empty room rows.