Excel mailmerge

[Barquentine]

I have a Word document linked to fields in an Excel spreadsheet. I also inserted a date field into the Word document but it never updates to today's date? This is MS Office 2007. Any idea where I'm going wrong? Thanks

[MarkRae]

1) Remove the field

2) Insert it again, but this time make sure you check the "Update automatically" box

[ChuckFickens]

When you inserted the date field there would have been an option to auto update the date on the window where you specified the format.

I'm not sure if you can change it once you've inserted it, but you can simply delete the date field and then add it again making sure you tick the auto update option.