Generating an automated email message

Here is what I am envisioning. The user completes a small html form (7
fields) and upon clicking the submit button, I would like an email generated
to a distribution group containing both the data entered on the html form
along with other information the recipient requires. If the ability was
there to email a confirmation page, that would be awesome.

The Email Results functionality in FP does not help me in the issue. Let me
through another piece into this scenario. If I choose to use an asp page to
store the data on my sql server, am I able to also email a confirmation page
to a distribution group.

Of course, I am open to other suggestions as well.

Help...

Ronx
Thu Feb 09 11:50:39 CST 2006

Using a custom script to update the database and send the email, you
can do as you wish. This cannot be done using the FrontPage database
wizards.

A White Paper explaining this is available at
http://www.microsoft.com/downloads/details.aspx?familyid=f813a835-ba04-4db9-883a-6bda125c27e6&displaylang=en


--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.
FrontPage Support: http://www.frontpagemvps.com/

"Ken D." <KenD@discussions.microsoft.com> wrote in message
news:6F6F5C02-DC6F-49FB-A2AB-E9FA6D475A0F@microsoft.com...
> Here is what I am envisioning. The user completes a small html form
> (7
> fields) and upon clicking the submit button, I would like an email
> generated
> to a distribution group containing both the data entered on the html
> form
> along with other information the recipient requires. If the ability
> was
> there to email a confirmation page, that would be awesome.
>
> The Email Results functionality in FP does not help me in the issue.
> Let me
> through another piece into this scenario. If I choose to use an asp
> page to
> store the data on my sql server, am I able to also email a
> confirmation page
> to a distribution group.
>
> Of course, I am open to other suggestions as well.
>
> Help...

Mike
Thu Feb 09 14:54:05 CST 2006

"Ken D." <KenD@discussions.microsoft.com> wrote in message
news:6F6F5C02-DC6F-49FB-A2AB-E9FA6D475A0F@microsoft.com...
: Here is what I am envisioning. The user completes a small
html form (7
: fields) and upon clicking the submit button, I would like
an email generated
: to a distribution group containing both the data entered
on the html form
: along with other information the recipient requires. If
the ability was
: there to email a confirmation page, that would be awesome.
:
: The Email Results functionality in FP does not help me in
the issue. Let me
: through another piece into this scenario. If I choose to
use an asp page to
: store the data on my sql server, am I able to also email a
confirmation page
: to a distribution group.
:
: Of course, I am open to other suggestions as well.
:
: Help...

Your best bet is as you suggested- an ASP page to store the
info into a database. After your sql insert, you can use
either CDONTS (NT4 or w2k servers) or CDOSYS (w2k- XP pro -
w2003) to create an email to 1 or several people.

p
Thu Feb 09 21:34:59 CST 2006

This is easily done with script.

..PC