Depending on what you mean, it may not be an excel problem.

Once you hit the link, excel will defer to whatever program you use for your
email client.

In windows XP, I can change that email client by:
Going into the control panel
Internet options|Programs tab
and specifying OE as the default email program.

I do remember having a problem once. That tab showed OE as the default email
program. I had to change it to something else, apply it, close the dialog (I
think???), then change it to OE.

But that was a longggggggg time ago and I haven't had any trouble since then.

(ps. I'm also use xl2003.)


Jeremy Brown wrote:

Does this work when you are using Outlook express? I've tried this under
Excel 2003 with poor results.

Jeremy

"Bill Manville" wrote in message
...
You could create the hyperlink with something like this:

?subject=Sales for " &
TEXT(TODAY()-0.25,"d-mmm"),"Send Sales")

This will give the date of 6 hours earlier.
Alternatively if you have a cell containing the date you want you could
use that in place of TODAY()-0.25

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


--

Dave Peterson