locked
Moving a string from a PDF from Outlook to Access. RRS feed

  • Question

  • Hello,

    I am wondering if there is a way to grab a string from a PDF attachment (it's a form with a specific number) and move that into an Access table automatically?

    Thanks,

    Nick

    Tuesday, July 25, 2017 1:51 PM

All replies

  • As far as I know there is no direct way to do it.  Word 2016 can open Pdf docs and you can use Word VBA to extract it.  Save the attachment and have Access open Word.  The other way is to convert the Pdf to a text or RTF doc.  I've used Calibre (free) to do this.  It has a command line interface.  You can call the command line from VBA.

    • Edited by mogulman52 Tuesday, July 25, 2017 5:15 PM
    Tuesday, July 25, 2017 5:12 PM