These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

form data via Outlook to Access db

Cameo
Registered: Dec 11 2006
Posts: 2

I want to send users a form to fill out as an Outlook attachment. Once they've sent the form back as an Outlook attachment, I want to insert their form data into an Access table. I have most of the steps completed, but cannot believe there isn't an easier way. It seems very manual at this point. I'm hoping you can show me a short cut or additional product I can use. I receive their data back in an .fdf or .xfdf format as an Outlook attachment. I must manually export this attachment to a directory, then open Acrobat to convert to .cvs, then open Access and read in this file. The problem is we are talking 100's of these replies. I need to automate. Plz help.

My Product Information:
Acrobat Pro 7, Windows
leonardr
Expert
Registered: Feb 14 2006
Posts: 333
Upgrade to Acrobat 8 and use the new "Distribute Form" feature. That will ease the distribution of the forms AS WELL AS the recollection of the data back into a single PDF Package from which you can export the data to a CSV file that can be imported into Access.

Leonard

Leonard Rosenthol
PDF Standards Architect
Adobe Systems