Generate path of a file in column and send email as attachment based on a cell value

[a_chaitanya]

Hi Team,

I have got a macro from one of the forum member "p45cal" to generate pdfs based on data validation list. The name of the PDFs generated is based on the list items.

Now here come my requirement, that, the generated pdfs which were in a folder should go as a attachment (using outlook 2010).

In the excel, with in a against the list of items there is a column named email.
Macro should find the name of the pdf and send the email with the attachment to the email in the cell.

Attaching the file for reference.

Thanks in advance.
Chaitanya

[a_chaitanya]

Also posted on http://www.excelforum.com/excel-prog...45#post3392545

[a_chaitanya]

Hi Team,Any suggestions some where i can find the solution from the team?

[Kenneth Hobs]

It is fairly easy. See, http://www.rondebruin.nl/win/section1.htm

[a_chaitanya]

Hi Kenneth,Thanks a lot for the site. I have gone through it, is able to send the sheets/workbook as attachment. But, I need the generated PDFs which where saved in a folder should be sent using outlook for the emails in a column of the excel file attached. The generated PDFs in a folder, the path of the individual PDF should be generated in the excel column and then be able to send the file as a attachment. Hope I am clear.Thanks.

[Kenneth Hobs]

No, that is not clear.

Did you download his pdf examples: http://www.rondebruin.nl/win/s5/pdf.htm

For the example showing how to add an attachment, see his function: RDB_Mail_PDF_Outlook()

If you know the pdf drive:\path\filename.pdf, then just use that string for the attachment in Ron's function.

Ron also provided examples on emailing to those in a range and shows the attachment option as well. http://www.rondebruin.nl/win/s1/outlook/bmail5.htm