Macro for Auto outlook email with attachment from excel

Hi,

I just want to share a scenario which I solved with help of this forum. I thank "ExcelForum" and its contributors for helping me.

This is the situation. I am having several excel files kept in a folder and I need to send those as an attachment to a list of email addresses. What I did is consolidated all the email address by "TO","CC","BCC" and "Subject" and the "Body" in another columns and the file name and its path in different columns.

Then I got a macro from this forum, did some changes and it is working fine.

Attached is the sample file with the macro in it.

Thank you "Excel Forum" and its members who did it.

aganesan99

Hi arlu1201,

I think I have described the situation and how I did that and also the macro for performing it.

Thanks,
aganesan99