might I point out that relying on email is an even less secure solution then web based forms.
On Fri, Jul 15, 2011 at 3:40 PM, Jochem van Dieten <[email protected]>wrote: > > 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:346235 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

