Date format in mail merge

If you Alt and F9 you will see the MergeFormat Field on your Word document.

If you type \@”dd/MM/yyyy” at the end of the field the date is displayed in that format.

To get the date format you want, you can add a formatting picture switch. In Word:
. select the mergefield;
. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyDate} where ‘MyDate’ is your mergefield’s name;
. delete anything appearing after the mergefield’s name and add ‘\@ “d MMMM yyyy”‘ to the field, as in {MERGEFIELD MyDate \@ “d MMMM yyyy”}. With this switch your date will come out as ‘2 August 2008’. Other possible date formatting switches include:
. \@ “dddd, d MMMM yyyy”;
. \@ “ddd, d MMMM yyyy”;
. \@ “d MMM yyyy”;
. \@ “dd/MMM/yyyy”;
. \@ “d-MM-yy”;
Note: you can swap the d, M, y expressions around, but you must use uppercase ‘M’s for months.
. position the cursor anywhere in this field and press F9 to update it;
. run your mailmerge.

Deixe um comentário

O seu endereço de email não será publicado. Campos obrigatórios marcados com *