mailto: formular

J

jiser

Hello,

I want to create a email-link.

Like in HTML
mailto:[email protected]?subject=Your%20Order%2054654&body=Dear%20John&20Johnson

Excel doesn't like this (as usual) and puts the whole link in the "to:
box. I'm definetly sure it is possible but dunno how :S

It's not possible to create a macro on this. The user got to have th
abiility to select a name from a (about 100 rows) list which he/sh
wants to email.


Does somebody have an idea
 
D

DNF Karran

As far as I can see you are doing it right- I just tried the followin
which worked fine. (xl 2k)

=HYPERLINK("mailto:[email protected]?subject=Your%20Order%2054654&body=Dear%20John&20Johnson","Mai
Someone")

Dunca
 
J

jiser

You're right !! Thank you !!. Perhaps my computer had a bad temper o
something ..........:rolleyes
 
J

jiser

almost forgot, somehow I can't use <br> to create a new return in th
email message. Do you know a way out ?
 
D

David

jiser < wrote
That's OK, Still I want to thank you for you support.

Somebody else know a way out ??
Click to expand...

This should get you going (with minor correction to your original):

=HYPERLINK("mailto:[email protected]?subject=Your%20Order%2054654
&body=Dear%20John%20Johnson%0A%0AHi There","Mail Someone")
 
C

CrankyLemming

David said:
This should get you going (with minor correction to your original):

=HYPERLINK("mailto:[email protected]?subject=Your%20Order%2054654
&body=Dear%20John%20Johnson%0A%0AHi There","Mail Someone")
Click to expand...

Is it possible to expanded on this to automatically attatch a
document, say "c:\\desktop\crankysdumbquestion.xls"?

I'm looking to have a button on a spreadsheet which will email that
sheet to someone, but don't think this is possible, as I guess the
document can't be attached to an email while it's open.

Thanks anyway

Steve
 
D

David

CrankyLemming wrote
Is it possible to expanded on this to automatically attatch a
document, say "c:\\desktop\crankysdumbquestion.xls"?
Click to expand...

Sorry, but I don't know. I'm sure more knowledgeable folks will jump in.
I'm looking to have a button on a spreadsheet which will email that
sheet to someone, but don't think this is possible, as I guess the
document can't be attached to an email while it's open.
Click to expand...

I know this is possible as a separate action from the =HYPERLINK method
because I do it myself:

ActiveWorkbook.SendMail "[email protected]"

I just don't know if both methods can be combined.
 
D

David McRitchie

You are kind of leaving the realm of Excel

You test by recording a macro
and trying it, but I don't think you will see anything.

I think it is really HTML, so you might try looking at something
I just located: (it had at least one pop-up)
html forms tutorial
http://www.angelfire.com/fl5/html-tutorial/forms.htm

But it looks like Ron already has it in his code.
look for
"Click here to see some tips for changing the Body and To line"
http://www.rondebruin.nl/sendmail.htm

--
 
Top