Code to send attachments to mail id s listed on excel sheet

[chaitanya051]

Hello,

I got some information on an excel sheet which includes a set of EMail ID s. Now I would like to insert some code ( Macros) into this excel sheet which upon running would send EMails to the people(ID s)listed in the excel sheet. All these EMails should include a predefined subject (present on the excel) and some text in the body along with a couple of attachments. Links(or paths) to all these are provided in the excel sheet. My code takes care of all this i.e it opens the text file from the given link and displays it in the sent mail. It also gathers the listed subject of the mail. But the problem here is that it does not attach the files to the mail being sent.

It just ignores the attachment part.

Im pasting the code i am using here

Please look into it and post your observations

any help would be appreciated

Thanks in advance

Please Login or Register  to view this content.