| Controlling date formats when merging from Excel 2003 to Word 2003 |
|
|
|
|
When you merge date fields from Excel into Word documents the date formats may be lost. To correct this:
1. From the Word mail-merge document, right-click the field name eg Start Date 2. Click the "Toggle Field Codes" option which will display something like {MERGEFIELD "Start Date"} 3. Edit the field to include a formatting control: \@ "dd/MM/yy" e.g. {MERGEFIELD "Start Date" \@ "dd/MM/yy"} 4. Preview the mail merge and the date format should be for example 31/12/08
|
| Next > |
|---|
| Fri 31 Oct @ 09:00 Speedwriting Skills London |
| Tue 11 Nov @ 09:30 Speedwriting |
| Wed 12 Nov @ 09:30 Speedwriting |
| Tue 25 Nov @ 09:30 MS Project Server Overview |
| Wed 03 Dec @ 09:30 Microsoft Accounting |