How to send email?

[abdullahsikandar]

Hi Guys,

First of all, thanks everyone for help..

I have few columns in Excel sheet, what i need is that a BUTTON, where we press that button it will send an email automatically to three email address, If the internet is not working then it will say check your internet connection, I want to provide the email address on the backend so no one will see the email address whom they are sending to just it will send the email to them once user click the Send button. In the email it will say Subject and attached that sheet or just the data.

Let me know please.

Thanks

 

[StephenCrump]

Ron de Bruin's site has some useful code that should get you started:

Mail from Excel with Outlook (VBA)
Sending mail from Excel with CDO