Tip of the Day
A couple people I know have had this problem which seems to affect Microsoft Word & Excel v2003 SP3.
Problem: When you mailmerge a field into Word from Excel that contains a date, the date appears in Word in international or US format, eventhough it is correctly formatted to UK layout in Excel.
Solution: Complete the merge document in the normal way. Before running the merge goto the field that contains the date.
1. right click on the field name e.g. > – see pop-up menu.
2. click on the ‘Toggle Field Codes’ option – see field expand e.g. {
MERGEFIELD “Date” }
3. edit the field to include \@ “dd MMMM yy” e.g. { MERGEFIELD “Date” \@ “dd
MMMM yy” }
4. preview your mail merge – see date in the format 1 April 11.


