When I select my spreadsheet from excel fir mail merge it appears with the
American Date format although my spreadsheet has the UK version my setting
are all english UK. Can anyone advise?

Hi Susan,

In Word:
.. select the mailmerge field and press Shift-F9 to expose the code. It should look something like {MAILMERGE XLDate}
.. after the data name ('XLDate' in the example) and *before* any other field switches (eg \* MERGEFORMAT), type any one of:
. \@ "dd/MM/yy"
. \@ "d-MMM-yyyy"
. '\@ "d MMMM yyyy"
. \@ "ddd, d MMM yyyy"
. \@ "dddd, d MMMM yyyy"
or variations on that theme (including the quotes) to get the date formatted as you like. Note the capital Ms for months.
.. press F9 to update the display.
.. run your mailmerge.

Cheers

--
macropod
[MVP - Microsoft Word]


"Susan" wrote in message ...
| When I select my spreadsheet from excel fir mail merge it appears with the
| American Date format although my spreadsheet has the UK version my setting
| are all english UK. Can anyone advise?