Mail merges

Hi Laura

Thank you for your question. Can you check what format has been applied to the cells containing dates in your spreadsheet. For example are they date format, with UK locale? You can check this by right clicking on a date in Excel and choosing Format > Cells > then click on the Number tab.

If the Locale is not UK then you may find the dates changed when they are imported into Word (which uses your PC's Locale to determine the date).

I have found an interesting suggestion on a Microsoft Forum relating for forcing the date format in a Merge document. It does in involves editing the merge field codes.

http://answers.microsoft.com/en-us/office/forum/office_2010-word/date-fomat-problem-in-mail-merge-word-2010/91e86ec7-1176-e011-8dfc-68b599b31bf5?auth=1

Let me know what you find in your spreadsheet and if changing the merge code looks like it might help.

Kind regards,
Andrew