Link to home
Start Free TrialLog in
Avatar of WNottsC
WNottsCFlag for Afghanistan

asked on

How to Embed a form into an email that writes to a database

We currently have a web based helpdesk application that we built.  This application sends out a number of emails at certain points along the life cycle of an incident.  One of these emails is an email to the client once the incident has been closed.

Within this email we wish to to embed som sort of form with a couple of questions about the service they received that once submitted would write back to a SQL server database.

One way I thought about doing theis was an embedded Infopath form that would submit to a SQL Database.

Is this possible and is there any other way to do this without having to purchase a third party tool
Avatar of Barry Gill
Barry Gill
Flag of United Kingdom of Great Britain and Northern Ireland image

it is possible, but most mail clients will disable the form. you are better of housing the form on a web page and merely providing a link to the page to the recipient. You can use unique URLS with a smart code as part of the URL to pre-populate the form with what you do know about that recipient.

Alos less likely to be blocked by AV/AS gateways.

Forms require scripts, scripts = VERY UNWANTED in email.
Avatar of WNottsC

ASKER

the clients that will be recieving this are only internal clients on our exchange server.  If this is possible how would you do it?  We suggested to our IT Director what you mentioned but he does not want the additional click
ASKER CERTIFIED SOLUTION
Avatar of Barry Gill
Barry Gill
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial