Mail merge date format

  • Thread starter Pieter van der Walt
  • Start date

Pieter van der Walt

I am doing a mailmerge using data from an Excel 2003 spreadsheet into a
letter template in Word 2003. How can I ensure that the date format used
within Excel is also carried over into the Word document during the merge.

In other words the cell value in Excel displays as "11/5/1980" and is
formatted using the cell formating as "11 May 1980". When doing the merge
over into Word only "11/5/1980" is transfered. How can I ensure that "11 May
1980" is transferred or displayed in Word?



Hi Pieter,

You can control the date format via a picture switch. To do this:
.. select the mergefield and press Shift-F9. You should see something like {MERGEFIELD ExcelDate}
.. change this to {MERGEFIELD ExcelDate \@ "d MMM yyyy"} (if you want September to display as 'Sep') or {MERGEFIELD ExcelDate \@ "d
MMMM yyyy"} (if you want September to display as 'September')
.. press F9 to update the field
.. run your mailmerge

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question