email sending

[msahmed]

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 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.

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

Thanks in advance...

[Kenneth Hobs]

Some pdfs are not readable. If you have Acrobat, not the reader, then one can get some text from it. Then it becomes a matter of parsing it if Fields were not used. Otherwise, if readable and not Acrobat, reading the text is fairly kludgy though some some 3rd party programs may make it a bit easier.

You are better off just creating the pdfs from Excel and then email.