Solved How can I automatically update dates on a template

Insert date/time method works fine for the current date in the body of the e-mail.

For the subject line, to add today’s date, I used the following method:
Select Design a Form from the Tools\Forms menu
In the Standard Forms Library Open the Message form.
Right-click on the Subject text input box and select Properties.
From the Properties dialogue box click on the Value tab and edit the initial value
as follows

‘my text ‘& Date()

1. The above worked fine, but it displays the date in mm-dd-yyyy format. I
would like this to be in mm-dd-yy format

2. For yesterday’s date (in the body of the e-mail) I tried Date ( )-1 and
Now ( )-1. These didn’t work.

As you mentioned this may be only accomplished by using macros.

Regards,
ocm