Hi there,

I want VBA code to automate the process of sending mail.

There are pdf files stored in a specific folder whose names are copied in an excel sheet. I need to send those pdf files through google's gmail as attachments. The issue is email address of the receiver is with in the pdf file.

I have found a code to send mails with attachments online but i dont know how to read the email address in those attachments and set it as to address in vba.

and yes those pdf files are in readable format and i have acrobat installed.

It would be great help if you sort me out of this.

Thanks in advance...