Send email from Excel custom list using outlook

Dear All,
I would like to develop a master file to send automated mail with the capabilities as mentioned below.

1. Pick the file (Macro enabled report file) from a specific folder and send to each client as mentioned email id
2. Email ids and Client details are mapped in the second sheet - "Email List"
3. Email Client list may go up to 600 Nos.
4. Custom message for each client is required.


I tried with some macro available in the net. But somehow it is not working.

Kindly help


Regards,
Leo Paul

Quote:

---

Originally Posted by leopaulc

Dear All,
I would like to develop a master file to send automated mail with the capabilities as mentioned below.

1. Pick the file (Macro enabled report file) from a specific folder and send to each client as mentioned email id
2. Email ids and Client details are mapped in the second sheet - "Email List"
3. Email Client list may go up to 600 Nos.
4. Custom message for each client is required.


I tried with some macro available in the net. But somehow it is not working.

Kindly help


Regards,
Leo Paul

---

Dear Administrator,

The solution worked well with the earlier threads.

Thank you... for creating a wonderful support :)

Glad you sorted out yourself with the help of other posts !