troubleshooting Question

HTML form and javascript to send form data in an xml file attached to an email of addresses from a SQL database

Avatar of paultran00
paultran00Flag for United States of America asked on
Microsoft SQL ServerJavaScriptHTMLXMLOutlook
21 Comments1 Solution2294 ViewsLast Modified:
Hi experts, I need your help please.

We don't have a web server.  I can use VB.net 2008 or C#.net 2008.  I am using Windows 7 Professional.  I am using Internet Explorer 8.  SQL SERVER 2008.

1. For an internal company user,  I want an html form to use  javascript to send the form's data in an XML file (not save an xml file because we can't do that from client side) and attached it to an email and send it to my Outlook inbox when a user clicks the SUBMIT button.  
(I will import the email from Outlook inbox with XML attachments into SQL SERVER).

2a. For an external company user, I want to extract data from a table of field1, field2, and email addresses in SQL SERVER , then on-the-fly dynamically create an html form with these fields populated in the form, and attach it to an email of addresses from SQL SERVER and send it out.

2b. For an external company user, when they receive the email from Step 2a, I want them to fill out the form then click the SUBMIT button which sends the form's data as an XML attachment back to my Outlook inbox.
(I will import the email from Outlook inbox with XML attachments into SQL SERVER).
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 21 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros