Email button???

H

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!!! :confused: :eek
 
F

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!!! :confused: :eek:
Click to expand...

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
 
H

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.:rolleyes:


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

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
 
H

hogiejax

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

Sub SendActiveWorkbook()

ActiveWorkbook.SendMail _
Recipients:="[email protected]", _
Subject:="TBO Termination Notification " & Format(Date,
"dd/mmm/yy")

End Sub
 
Top