Mail merge with excel

[Carl_61]

I have created a mail merge letter that is meant to merge in dates taken from my excel spreadsheet.  I have in there a statement that says something like, The start date of this event is “Date” to “Date”. Another words, Begin Date and End Date. The problem I have is the end date will not display or print the end date as a date. It will only show or print as numbers representing the date. I have tried switches to no avail. I’m pulling my hair out here. Anyone know how to fix this.  I have my dates in the decline formatted as date and switches attached to the mail merge fields. Just can’t get it to show the dates I so desperately need.  HELP

CARL

[#2]

@Carl_61 

I appreciate the views but can anyone please help me out with why my dates coming from Excel are displaying as numbers. I am using the switches but they are being ignored. If no one can help, does any one know the best support number to call at Microsoft?

[#3]

@Carl_61 Can you provide a copy of the mail merge main document so that we can investigate the issue.

[#4]

Also, a sample from the data file that demonstrates the problem.

[#5]

I will work to make that happen.
Thank you

[#6]

I will work to make that happen
Thank you