Todays date in subject field of mailto hyperlink formula

Hi everyone,

I have the formula for generating an email and poulating a subject and body field. However, I want the subject field to contain todays date.

When I type =today() in cell A1, and the required email address in A2, and use the following formula for my mailto hyperlink:

=HYPERLINK("mailto:"&$A2&"?subject="&A1&"-Meeting Scheduled","Send Email")

I get the following in the subject line of Outlook:

42580-Meeting Scheduled

How can i get todays date in the subject field of my email, and it actually be the date instead of Excel time-date number??

Olly,

You're a legend. That's nailed it.

Thanks pal!