One click workbook email?

[Drew]

Greetings,
Is it possible to set up something (macro, hyperlink,
etc.) to attached the open workbook to an email message
that goes to a specific email address... all with one
click?

Basically, I'm looking to combine the functionality of
File/Send To/Mail Recipient (As Attachment) and
Hyperlinking to an email address.

Any help would be greatly appreciated and thanks in
advance!
-Drew

 

[Frank Kabel]

Hi
as a starting point
http://www.rondebruin.nl/sendmail.htm

 

[Guest]

Frank,
Thanks. That's fantastic.
-Drew

-----Original Message-----
Hi
as a starting point
http://www.rondebruin.nl/sendmail.htm

--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[Drew]

Frank,
I read through many of the articles and found them very
helpful. Do you know if there any way to modify the
SendMail command so that text can be added to the body of
the email before it is sent?
Thanks in advance,
Drew

 

[Frank Kabel]

Hi
probably best to ask Ron

 

[Ron de Bruin]

Hi Drew

Not with SendMail if you want to do it with code
Above every SendMail example you can read this

Note: With SendMail it is not possible to
1) Send text in the Body of the mail
2) Use the CC or BCC field
3) Attach other files

But if you don't fill in a address you can enter text in the body.
.SendMail "", "This is the Subject line"

If you use Outlook then it is possible with code
Look at the Outlook examples on my site
<Outlook object model >

 

[Peo Sjoblom]

I don't think so, but you can look at the CDO instead, same page.
I used the CDO method and sent a rather large body message
(463 words 2593 characters) for a non profit

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Drew]

Thanks Ron. I've read through allot of your material on
your web page (and some things you wrote when I Google'd
SendMail) and found it to be quite helpful.

I'll see what I can come up with but I'm well on my way
to accomplishing what I had hoped.

Thanks,
Drew