Hi 123Jump,

To correct this, you could change your mailmerge connection method to DDE, or you could modify the mailmerge field code. To do the
latter, select the mailmerge field and press Shift-F9. It should look something like:
{MERGEFIELD ExcelDate}
Change it to any one of:
{MERGEFIELD ExcelDate \@ "d/M/yyyy"}
{MERGEFIELD ExcelDate \@ "dd/MM/yyyy"}
{MERGEFIELD ExcelDate \@ "d-MMM-yyyy"}
{MERGEFIELD ExcelDate \@ "ddd, d MMM yyyy"}
{MERGEFIELD ExcelDate \@ "d MMMM yyyy"}
{MERGEFIELD ExcelDate \@ "dddd, d MMMM yyyy"}
etc, to create the exact format you want, independently of whatever the format is in Excel.

Cheers