(Msg. 1) Posted: Tue Jul 01, 2008 7:50 pm
Post subject: Creating a mail link Archived from groups: microsoft>public>excel>links (more info?)
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.
(Msg. 2) Posted: Wed Jul 02, 2008 7:50 am
Post subject: Re: Creating a mail link [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 3) Posted: Fri Jul 04, 2008 4:50 pm
Post subject: Re: Creating a mail link [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Does this work when you are using Outlook express? I've tried this under
Excel 2003 with poor results.
Jeremy
"Bill Manville" <Bill-Manville.RemoveThis@msn.com> 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
>
(Msg. 4) Posted: Fri Jul 04, 2008 4:50 pm
Post subject: Re: Creating a mail link [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <Bill-Manville.RemoveThis@msn.com> 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
> >
(Msg. 5) Posted: Fri Jul 04, 2008 8:49 pm
Post subject: Re: Creating a mail link [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 6) Posted: Mon Jul 07, 2008 11:47 pm
Post subject: Re: Creating a mail link [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <Bill-Manville.RemoveThis@msn.com> 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
>
(Msg. 7) Posted: Tue Jul 08, 2008 7:58 pm
Post subject: Re: Creating a mail link [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 8) Posted: Tue Jul 08, 2008 9:29 pm
Post subject: Re: Creating a mail link [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <Bill-Manville DeleteThis @msn.com> 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
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office