mailto: formular

[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

 

[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

 

[jiser]

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

 

[jiser]

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

 

[DNF Karran]

Too far into HTML for me I'm afraid, not even sure what that does

Dunca

 

[jiser]

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

Somebody else know a way out ?

 

[David]

jiser < wrote

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

Somebody else know a way out ??

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")

 

[CrankyLemming]

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")

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

 

[David]

CrankyLemming wrote

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

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.

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

ActiveWorkbook.SendMail "(e-mail address removed)"

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

 

[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

--