Automatic email

[dwarek]

Hello Everyone i have been assigned a task in my office to send multiple email by using one button,i guess i have to write a vba code for that. I have seen few vba codes but my requirement is bit different. I need code which extract data from the worksheet and send a mail via outlook . Is it possible to do like that ? please help me if so Thanks in advance

 

[Domenic]

See if you can find what you need in the following link...

https://www.rondebruin.nl/win/s1/outlook/mail.htm

 

[Michael M]

You will also need to provide much more detail....which rows / columns hold the emai address ?
Where is the data ??....etc, etc !!

 

[dwarek]

mail id in column A and few data in column B and C and one more data in sheet 2 column A
It need to be printed in outlook like sheet 2 column A data space sheet 1 column B data space sheet 1 column C data
can you please help me out