Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

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 ...so 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 83

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 83

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.
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.


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
LVL 83

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

Simon 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 ....lol
many many many thanks im very greatful

Author Closing Comment

ID: 40541013
many thanks to all great solutions

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

839 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