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 ...
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?
- For me it works just fine provided I make sure the Excel file is not open in Excel when I open the Word file.
Attached are Pics of what I am getting or how mine is set up. No matter what I do I keep ending up with numbers for the end date.
Carl
- Are there settings in settings that may not be correct? Who would ever want to see the date numbers as no one would understand what the date is anyway. For visualizing, this seems like such a waist.
Attached are the 2 files that I am working with. As you can see, most data has been removed and or altered. I have tried everything I can think of but I keep getting numbers for the End Date. This is driving me insane. I have tried switches but nothing changes for me in regards to the end date. HELP PLEASE
- Yes, I will work on that
