View Single Post
 
Old 01-17-2018, 03:40 PM
Townshend Townshend is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2018
Posts: 4
Townshend is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Possibly, but I'm not that fluent in SQL.

That suggests you're typing the braces instead of inserting them via Ctrl-F9. Tow things to note:
1. A plain DATE field will update every time you open the mailmerge output document. The Mailmerge Tips & Tricks 'sticky' thread at the top of this forum has an entry showing how to overcome that.
2. A CREATEDATE field returns the date the mailmerge main document was created, not the date the output document is created (unless you then do a SaveAs and refresh the field display).
QUOTE did the trick, thanks!