general excel to control mail send

[roby_joshua]

I have to create an excel which can open any excel and can read emailids in that excel to send messages from outlook.So the excel to be created should have parameters like suject ,body,cc,recipient .pls help me in finding it.I dont know how to control one excel from another.

[dominicb]

Good morning roby_joshua

...and welcome to the forum!!

You haven't given much information about exactly what you want to do, so I'll point you towards Ron de Bruin's website. He has an add-in available which will help you integrate your Excel with Outlook :
http://www.rondebruin.nl/mail/add-in.htm

If you'd rather pull the code together yourself, you need to start off with his Outlook VBA pages :
http://www.rondebruin.nl/sendmail.htm

In my opinion this is the best Excel / Outlook resource on the net.

HTH

DominicB

[roby_joshua]

i want to send email by reading all email ids from the excel.For tat purpose i have to create an excel generally to send mail from any excel