HELP!Need a macro that gets the data from an excel sheet and sends the mail automatically.

Hello everyone,

I m new to this forum.
Can somebody please help me on:-
Making a macro that fetches the data from an excel sheet and emails the fetched data through outlook to the required recipients.
Thanks in advance
Prodyumno

Hi Welcome in Excel Forum,

Dear Friend,
You can search Google for your problem. Lots of examples you can find there regarding Excel to Outlook data transfer. Why I am asking to do so because you can explore lot of things there.

Regards
taps

yeah i have done but not getting exact type of code required for my task as i am not sound in VB...took the code in the net and applied but didnt get the expected result.
Kindly help.

this is where i got help for my code

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

this is for a range:

Please Login or Register  to view this content.