Insert text and date that is 1 day ago in Outlook subject

[tmmullin]

I would like to make a macro that inserts certain text followed by a date that is one day before the current date. For example, since today's date is December 19, 2007, the subject line should say

"Such and such report for December 18, 2007"

Any suggestions?

Thanks,

Todd