After playing with this for a while let me update with more information,
though I still haven't solved the problem.

The mail merge is pulling the date from a spreadsheet cell with a formula,
not the original data cell. After some testing, I think this may play a part
in the problem but I don't know how to fix it.

"mgerken79" wrote:

I have a mail merge set up to merge a date field from excel. For a while it
was working perfectly, date was coming in the right format, as a date. Now,
for some unknown reason it is coming over as a date number code and I can't
figure out how to fix it. I've changed the excel cell format to date so it
appears as a date in excel but still comes over as a date code. Help please!
Going out of my mind.