Email button???

[hogiejax]

Hi everyone!

Please forgive me if this is something that has been addressed befor
in a thread. I did a search and had no luck

Here is my problem: I have an Excel worksheet that I need my manager
at work to complete and send to a few people. They always forget t
send it to ALL the people. I heard from someone that there is a way t
set up a button on the worksheet that the user can click when they ar
done filling it out. The button would automatically open your emai
program, attach the worksheet (as attachment) and fill in the "mail to
section? *-Is this true?-* If so, how possible is this for a beginne
to do? Help!!! :eek

 

[Franz Verga]

Nel post *hogiejax* ha scritto:

Hi everyone!

Please forgive me if this is something that has been addressed before
in a thread. I did a search and had no luck

Here is my problem: I have an Excel worksheet that I need my managers
at work to complete and send to a few people. They always forget to
send it to ALL the people. I heard from someone that there is a way
to set up a button on the worksheet that the user can click when they
are done filling it out. The button would automatically open your
email program, attach the worksheet (as attachment) and fill in the
"mail to" section? *-Is this true?-* If so, how possible is this
for a beginner to do? Help!!!

As a friend of mine always says, Google is your friend...

Try to check these:

http://snipurl.com/s77o

http://groups.google.it/groups/search?q=email+from+excel&start=10&


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[hogiejax]

Thanks. Per the attached screenshots, I added a "send" button and coded
it to attach the file to an email and address the recipients. When I
click the button, it is "dead" and nothing seems to happen. Any idea
why this is? I have gotten a little firther than before.


+-------------------------------------------------------------------+
|Filename: macro 1.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4934 |
+-------------------------------------------------------------------+

 

[Ron de Bruin]

Hi hogiejax

We can't see your jpg in the normal newsgroup
Which mail program do you use and show use the code you use

 

[hogiejax]

Here is the exactly what I typed. Am I missing something?

Sub SendActiveWorkbook()

ActiveWorkbook.SendMail _
Recipients:="(e-mail address removed)", _
Subject:="TBO Termination Notification " & Format(Date,
"dd/mmm/yy")

End Sub

 

[Ron de Bruin]

Which mail program do you use

See this page also
http://www.rondebruin.nl/mail/problems.htm