Open Outllook through VBA
 

I would like to send the report generated (Excel sheet) from VBA to various
receipients. I have certain queries

1. How to write VBA to send mails from excel
2. How to attach certain files to send mail - VBA codes ?
3. How to send current sheet as body message through Outlook - VBA codes to
these activities

Can anyone help me to do the same.

Thank you

Open Outllook through VBA
 

Hi Vijay

Start here
http://www.rondebruin.nl/sendmail.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Vijay Kotian" wrote in message ...
I would like to send the report generated (Excel sheet) from VBA to various
receipients. I have certain queries

1. How to write VBA to send mails from excel
2. How to attach certain files to send mail - VBA codes ?
3. How to send current sheet as body message through Outlook - VBA codes to
these activities

Can anyone help me to do the same.

Thank you