Add an auto update date field to an HTML mail merge template

More information:

Please amend your mail merge view for the entity required e.g vMailMergeCompany

Convert(varchar, GETDATE(),111) AS CurrentDateTime:  

Example output from implementing this statement: 2013/02/13

Depending on the date format required you can amend the sql statement to one of the below: