Send email automatically

M

Maria K Brickl

Is there a way to send an email automatically from Excel? We have this macro
set up that when you click on it, it will open up an email. What we would
like it to to do is address the email message and then send automatically.

Is this possible? And if so can someone help me?

Thanks!

Maria Lindquist
UW Colleges
 
M

Maria K Brickl

The trigger to send the email will be the push of the button that says "Send
email"
 
D

David McRitchie

Hi Maria,
What kind of help do you want.

Is the part that you have a macro set up to open email relevant,
to the question, because I don't know how you do that part.

Where is this code to go that you want when composing
and email reply. Are you using anything other than the
sender's email address -- if so I'd like to know how you
read the email and captured the email address.

Is the send button the normal "send" button in Outlook Express.

What makes this an Excel related question, what are doing
from Excel.
 
M

Maria K Brickl

Thanks! This worked great!!!!! You wouldn't have code that automatically
submits to public folders would you too?
 
D

David McRitchie

Now that we know the answer was Ron's site, I'm even
more curious about the question.
 
G

Glenn

How do you put that code into excel so that it will work? I've tried
putting it in as a module, but I don't know what to do on the sheet it self
to make it work.
 
G

Gord Dibben

Glenn

If you're inquiring about Ron's Sendmail add-in, you stick the add-in into
your Office\Library folder then go to Tools>Add-ins and put a check beside the
add-in.

Gord Dibben Excel MVP
 
R

Ron de Bruin

Hi Glenn

There is a great Help file on my website also.
(Made by Norman Harker)

Have you read it?
 
Top