?
Solved

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

Posted on 2010-08-16
3
Medium Priority
?
268 Views
Last Modified: 2013-12-18
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
0
Comment
Question by:WNottsC
[X]
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
  • 2
3 Comments
 
LVL 9

Expert Comment

by:Barry Gill
ID: 33445354
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.
0
 

Author Comment

by:WNottsC
ID: 33445473
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
0
 
LVL 9

Accepted Solution

by:
Barry Gill earned 2000 total points
ID: 33445661
you could use info path forms, but should still seriously consider this. Scripting of any kind is ill advised as AV systems really don't like it and creating exceptions allows holes to form for nasty folk to take advantage of.
You should in truth be directing to a website (sharepoint?) this is not an inconvienience to do and you could probably set up a reminder system too if they have not responded within an alloted timescale.

0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
The main intent of this article is to make you aware of ‘Exchange fail to mount’ error, its effects, causes, and solution.
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…

649 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