Simple but I don't know how...

[Guest]

Hallo everybody,

I have excel sheet with email functions in the panel tools. There are
buttons for send email, to choose who is recipient, to whom will be send via
copy etc... There is fully integrated mail function and sheet look little bit
like that it is real mail.. How is it possible to do something like that? Or
where I can find more detail information?

 

[Jeni Q]

Are you talking about mail options in the toolbars and menus? That is
possible becuase Excel and Outlook are integrated. If you're not running
Outlook, I wouldn't be too hopeful that it would work.


: Hallo everybody,
:
: I have excel sheet with email functions in the panel tools. There are
: buttons for send email, to choose who is recipient, to whom will be send
via
: copy etc... There is fully integrated mail function and sheet look little
bit
: like that it is real mail.. How is it possible to do something like that?
Or
: where I can find more detail information?
:
:
:
:

 

[David McRitchie]

You've already described how you can do it, and it is not clear to me what
you want to do differently. I would suggest taking a look at Ron de Bruin's
page and if you don't quite find what you want then post back to this thread
with a description of what you want. "real" email ? You should be tying
into your default email.

Good for Outlook and OE
Example Code for sending mail from Excel
http://www.rondebruin.nl/sendmail.htm
Page is not listed on his home page, perhaps because he has an
addin that listed there that is only good for Outlook (not OE).

How to send email from HTML and from Excel
http://www.mvps.org/dmcritchie/excel/excel/mailmerg.htm

 

[David McRitchie]

The last page link on Ron's page is for "Tips" and that page points to
his email page (Send mail).

Jeni brings up a point. What email reader/browser are you using
and what operating system. Because you question hints at using
something else.

 

[Ron de Bruin]

Hi David

addin that listed there that is only good for Outlook (not OE).

http://www.rondebruin.nl/mail/add-in.htm
Version 2 is for OE and Outlook and version 3 is only for Outlook

 

[David McRitchie]

Okay, and I also notice now that sendmail page
http://www.rondebruin.nl/sendmail.htm
with macros is specifically mentioned on your home page within
the paragraph for the SendMail Addins, and from your answer I
know why addins is plural (two versions).