PDA

View Full Version : email sending



msahmed
09-30-2016, 11:45 AM
Hi there,:hi:

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

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

Thanks in advance...

Kenneth Hobs
10-01-2016, 05:53 AM
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.