Hi I'm wondering if anyone found out why there was an issue with the date format in word when doing a mail merge? I am merging data from excel into a word document- the date format the dates are set up in excel is dd/mm/yyyy but when merged into word they transfer over to mm/dd/yyyy. Its very odd as there are 2 different fields for dates and only one of the fields changes format. Does anyone have any ideas how I can fix this?

Try adding the following to the date field on the word document after the date field name:
\@"ddMMyyyy". It should reformat the date to day/month/year. the quote marks and case are important. If this doesn't work try googling mail merge date field format, thats where I found the solution a few years ago.