Thanks, Remou, I tried that but still no joy. I ended up formatting the field as a Long Date in both the MS Access Table and Query, then pasting the results of the query into an Excel Spreadsheet. I used the spreadsheet as the source for the mailmerge and it worked a treat.
Thanks for the help.
I am creating a MailMerge Document from a query on an Access database. As I live in Ireland the date format on the database is Short Date dd/mm/yyyy. When I preview the MailMerged Word document, the order has been reversed to mm/dd/yyyy.
My Regional Settings are set correctly in Control Panel...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.