automating forms through email or adobe orwinform

Posted on 2015-01-09
Last Modified: 2015-01-09
hi, well there are two things here, and since i dont really know how to go about this i might have to post the other question in another area, but i will try...anyway, i like to send out a form (to many many recipients) through email that should be filled then returned to me.
Now, since it will be alot of forms, (which is the reason i desire a solution) i need to automate these forms as in as soon as i receive them i will save them and using (creating) some VS2010 app or some other way, i need to have the name field in these forms to be extracted or copied whatsoever to another document (certificate) with a name field i can avoid looking through each email or form and writing the name down, then again typing it the certificate then print it, it is a symposium and many participants are involved.
Question by:ahashash
  • 4
  • 3
LVL 82

Accepted Solution

Dave Baldwin earned 250 total points
ID: 40539800
Email is Not a good way to do this.  I don't know of a way to make the form in the email work properly.  A web page with a form (which can be a link in an email) that submits the form data to a page that puts the info in a database is the best way to do this.  This makes the information available for any other program you use to get it from the database and use it however you need it.  Making certificates, sending more emails, what ever you want.

Author Comment

ID: 40539815
thanks dave, sounds great and i will do as you suggested, just one more question, say i got them to fill hte form and stored info on the website's database, how (of the many ways i guess) but an easy one to get the name or name field to be automatically copied to a word doc ? and thanks in advance for your support
LVL 82

Expert Comment

by:Dave Baldwin
ID: 40539893
About the Word doc, I don't know, I've never had to do that.  If you are doing a lot of them at once, you can probably export the data as a CSV file and import into Excel and essentially do a 'mail merge'.  There may be easier ways but like I said, I've never needed to do that.

Author Comment

ID: 40539908
thanks dave i will then wait a bit for other suggestions and if none then i will try the method you spoke of....many thanks
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

LVL 82

Expert Comment

by:Dave Baldwin
ID: 40539921
You should get some response during the day.  If not, click on "Request Attention" above to get some people to look at your question.
LVL 18

Assisted Solution

SimonAdept earned 250 total points
ID: 40539941
I tend to agree with Dave, that a web form is the best scalable way to do this, provided that you already have the infrastructure in place to support it. However, this is not always the case. It could be onerous if you don't already have your own webserver or hosting arrangement.

One method we use successfully for smaller projects is to send out Excel or Word forms via email and use VBA routines to process returned forms (log receipt, validate content, write form content to spreadsheet and/or database). This is not so scalable for high volumes but do-able with just standard MS Office products.

Author Comment

ID: 40539944
oh dear, i never knew that, no wonder i some questions were frozen
many many many thanks im very greatful

Author Closing Comment

ID: 40541013
many thanks to all great solutions

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now