stanl
11-06-2008, 06:42 AM
We are experimenting with eFax - where workorders are faxed and arrive as PDF's rather than being mailed, then scanned to PDF.
Often several workorders are faxed in batch - each can be 2-3 pages which includes the workorder, signed contract, and perhaps an additional warranty
We set up an 800 number which routes to an email address and I have no problem opening the emails, extracting the headers/body into fields in an access table, then using an ADO Stream to place the PDF as a binary object in another field for later export/viewing.
If I open an exported PDF in Acrobat 8 - there is an option to export to text, and even though the entire pdf is an image, the OCR functionality of Acrobat gives me enough to interpret the page # and workorder # so I can parse that data as addtional field info.
I have used VBA with Acrobat up to version 6.0, so I can code the creation of and loading of the pdf
'Initialize Acrobat by creating App object
Set gApp = CreateObject("AcroExch.App")
gApp.Hide
'Set AVDoc object
Set gAvDoc = CreateObject("AcroExch.AVDoc")
I am assuming I need
gApp.MenuItemExecute("[Something]")
but I can't figure out what [Something] is. Sure would appeciate a code snippet to get any readable text to a variable.
TIA Stan
Often several workorders are faxed in batch - each can be 2-3 pages which includes the workorder, signed contract, and perhaps an additional warranty
We set up an 800 number which routes to an email address and I have no problem opening the emails, extracting the headers/body into fields in an access table, then using an ADO Stream to place the PDF as a binary object in another field for later export/viewing.
If I open an exported PDF in Acrobat 8 - there is an option to export to text, and even though the entire pdf is an image, the OCR functionality of Acrobat gives me enough to interpret the page # and workorder # so I can parse that data as addtional field info.
I have used VBA with Acrobat up to version 6.0, so I can code the creation of and loading of the pdf
'Initialize Acrobat by creating App object
Set gApp = CreateObject("AcroExch.App")
gApp.Hide
'Set AVDoc object
Set gAvDoc = CreateObject("AcroExch.AVDoc")
I am assuming I need
gApp.MenuItemExecute("[Something]")
but I can't figure out what [Something] is. Sure would appeciate a code snippet to get any readable text to a variable.
TIA Stan