Thanks TrainableMan, that is the answer. I've just made the change in my document and it works. (I'm using Office 2007)
To complete this thread for anyone else who has found it the solution is:
- All you need to do is add some extra code to change the formatting. Presuming your original table field is called 'Date', the merge field will currently be {MERGEFIELD "date"}
- To change the mailmerge date field format you need to change the relavent merge field by changing the view to show the field codes.
- To do this right click on the merge field and select toggle field codes.
- You need to add the following formatting data \@"dd MMMM yyyy"
- So your field will now look like this {MERGEFIELD "date"\@"dd MMMM yyyy"}
- Note: you may need to add " marks before and after the table field as well and the code is case sensitive, so putting mmmm will not work.
- Right click the file again to revert to the field name view. When you preview the document you will see that dates are now formatted in the long date format.
Hope it helps