Creating a mail link

Hello,
I am looking to create a mailto: link in an Excel spread sheet that puts the
date of the form as part of the subject.

eg: Subject: Sales for 7/1/2008

The "Sales for" would always be the same but the date would be taken from
the top of the form.

As a note, our business day extends past midnight, so something equivalent
to the "=today()" function would not work as it would credit the date at the
time of closing as the current date as opposed to date of the business day.
I was hoping it could take the date we enter at the beginning of the day as
the date it uses in the subject line.

Jeremy

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

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

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

Don't know about Outlook Express; I use Outlook and it worked OK for
me. What happens when you try it?

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

the To field has emailtoffice, while the subject is everything after -
"text" =(formula"&)

I am using Office XP with Outlook Express.

Jeremy

"Bill Manville" wrote in message
...
Don't know about Outlook Express; I use Outlook and it worked OK for
me. What happens when you try it?

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

Burger King Framingham wrote:
the To field has emailtoffice, 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

I did a copy and paste of your information then edited the fields. What I
was basically saying that the To field had the mailto:comment while the
subject had the text that came after the "subject=" section, but I mistyped
the data in my previous response. Sorry for the confusion. I will try the
second line once I get the chance tonight.

Thank you again,
Jeremy

"Bill Manville" wrote in message
...
Burger King Framingham wrote:
the To field has emailtoffice, 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