Creating a mail link

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

date: Tue, 01 Jul 2008 19:50:37 GMT author: Burger King Framingham

Re: Creating a mail link

You could create the hyperlink with something like this:

=HYPERLINK("MailTo:MyName@MyISP.com?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

date: Wed, 02 Jul 2008 07:50:57 GMT author: Bill Manville

Re: Creating a mail link

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 
news:VA.000014b1.27e271e6@msn.com...
> You could create the hyperlink with something like this:
>
> =HYPERLINK("MailTo:MyName@MyISP.com?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
>

date: Fri, 04 Jul 2008 16:50:11 GMT author: Jeremy Brown

Re: Creating a mail link

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
> news:VA.000014b1.27e271e6@msn.com...
> > You could create the hyperlink with something like this:
> >
> > =HYPERLINK("MailTo:MyName@MyISP.com?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

date: Fri, 04 Jul 2008 13:53:08 -0500 author: Dave Peterson

Re: Creating a mail link

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

date: Fri, 04 Jul 2008 20:49:42 GMT author: Bill Manville

Re: Creating a mail link

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

I am using Office XP with Outlook Express.

Jeremy

"Bill Manville"  wrote in message
news:VA.000014b3.34f82249@msn.com...
> 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
>

date: Mon, 07 Jul 2008 23:47:56 GMT author: Burger King Framingham

Re: Creating a mail link

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):
=HYPERLINK("MailTo:MyName@MyISP.com?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

date: Tue, 08 Jul 2008 19:58:06 GMT author: Bill Manville

Re: Creating a mail link

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
news:VA.000014b4.49625554@msn.com...
> 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):
> =HYPERLINK("MailTo:MyName@MyISP.com?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
>

date: Tue, 08 Jul 2008 21:29:24 GMT author: Burger King Framingham