Burger King Framingham wrote:
the To field has emailto:office, while the subject is everything after -
"text" =(formula"&)


I don't think you could have copied my model very accurately.

Try adapting the following first (note MailTo, not eMailTo):
?subject=Sales" ,"Send Sales")
and if it doesn't work, post the formula as you used it and the effect in
Outlook Express.

If it does work, change it so that the formula ends
?subject=Sales" & TEXT(TODAY()-0.25,"d-mmm"), "Send Sales")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup