Macro to create new email and send it with attachments stored at a particular location

Hello Experts,

Need your help once again in creating a macro.

The object of this macro is to create a new email for every column in the attached file.............have a certain subject line, have a certain text in the body and attach a certain file from a certain location.

I hope the attachment makes things clearer.

Requesting your urgent help on this.

Regards,
Ash

"Mail It.xlsm" is surely helpful...........but is there a way to send out bulk emails with the required data as shown in my original file?? Maybe we can do some tweaking within "Mail It.xlsm"?

Something like........... I input all the data and click on one button and it send out all the emails(whether it is 1 or 20).

Sender of the emails would be the person using that macro workbook.
Receiver of the emails would always be either person 1 or person 2 no one else.
CC would always be 1 person.
Subject line will change with every email.
Attachment names will change with every email but the attachments' folder location will always be the same.

Thanks Logit, for taking out the time to start on this.............please take your time and see if you could come up with something awesome!!!

I was thinking if I could have it by 1st week of Jan'17 that would be great.


In the meantime, calling out to other experts on this...... Please help.

Originally Posted by Ash_Maverick

Thanks Logit, for taking out the time to start on this.............please take your time and see if you could come up with something awesome!!!

I was thinking if I could have it by 1st week of Jan'17 that would be great.


In the meantime, calling out to other experts on this...... Please help.

Ash_Maverick, you have enough experience on this forum that I think you know how things work here. You have posted in an area reviewed by people willing to give some time for free to try to help people get questions answered or get over a hump. Logit has provided some valuable starting points for you to work from. From the tone of your latest post I am getting the sense that you are looking for someone to provide a complete solution for your specific problem and don't plan on doing any work yourself.

If you would like to engage someone on that basis it is appropriate to offer payment in our Commercial Services forum, where you can specify the date you need it by, and expect people to develop an entire solution for you in return for a modest payment.