a_chaitanya
09-03-2013, 06:01 AM
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
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