Send email automatically

  • Thread starter Thread starter Maria K Brickl
  • Start date Start date
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
 
The trigger to send the email will be the push of the button that says "Send
email"
 
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.
 
Thanks! This worked great!!!!! You wouldn't have code that automatically
submits to public folders would you too?
 
Now that we know the answer was Ron's site, I'm even
more curious about the question.
 
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.
 
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
 
Hi Glenn

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

Have you read it?
 
Back
Top