On Wed, Jul 13, 2011 at 10:13 PM, Scott Spurlock wrote: > Yes, this is what I'm trying to accomplish. My client wants a PDF (or Excel > or Word) form that he can send to people, have them fill out, and email back > to him.
Easy so far with a PDF form. You can configure it to send back either XML or the filled out PDF. > He then wants to be able to import that data into an Access database without >having to retype anything into an Access form. With a PDF form there are 2 solutions: - hook up the receiving mailbox to some server solution (for instance LiveCycle or ColdFusion) and let the server solution parse the data and fill the database; - manually open each email, save the attachment to a folder and process the attachment. For processing the attachment you can either do something with having the clients submit is as XML and processing the XML using VBA(?) or you can have the clients submit as PDF and extract the results as a .csv from a directory of PDFs and then import the .csv to Access. Since it looks like circumstances force you to go the manual route, how much time is the client willing to spent per received response? 3 minutes? 1 minute? 10 seconds? What volume are you looking at? Would the client be compatible with one of the licensing options described at: http://help.adobe.com/en_US/Acrobat/9.0/3D/WS58a04a822e3e50102bd615109794195ff-7e0d.w.html Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
