Solved How can I automatically update dates on a template

March 15, 2013 at 08:32:55
Specs: Windows 7
How can I automatically update the following dates every time I open my outlook template?

Subject: report for: <today’s date> in “mm/dd/yy” format

Body of e-mail:
…first I ran the report using: <yesterday’s date> “mm/dd/yy” format
…and I ran the report using: <today’s date> “mm/dd/yy” format

Thanks, OCM


See More: How can I automatically update dates on a template

Report •


#1
March 16, 2013 at 02:09:32
You can update to the current date and time in the template by simply clicking the 'insert' menu, select 'date and time' then select the format you want and put a tick in the 'update automatically' box. However, adding the 'yesterdays date' requires some sort of macro, but it should still be possible.

"I've always been mad, I know I've been mad, like the most of us..." Pink Floyd


Report •

#2
March 16, 2013 at 19:07:34
✔ Best Answer
Johnr, thanks for your reply.

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


Report •

Related Solutions


Ask Question