Infuriating Mail Merge Issue (1 Viewer)

[mimottershaw]

Please help!

I have just finished creating an Office application to store, manipulate and report data. I enter data in Access. Excel imports and manipulates it, nad then a Word mail merge outputs the report. I had been working with test data that worked fine. I deleted the data in access, and re-entered "live" data. When I went back to the mail merge none of the dates would format correctly. It doesn't matter hoe many times or ways I try to set the date format switch, it stubbornly displays the date as a number. The only thing I have changed is the source data in Access, so I don't know how this can be happening??? I have read somewhere about Excel reading the first eight rows to identify a data type, but I am not sure what to do about it, even if that is the problem.

Can anybody help please?????
Mark

 

[boblarson]

Mark:

Instead of deleting a post because you found the answer, you should post your solution so that others can be helped in the future.