PC Review


Reply
Thread Tools Rate Thread

Best way to deal with user forms

 
 
Craig Schiller
Guest
Posts: n/a
 
      25th Jul 2004
Hi, all -

I'm probably going to be designing the website for a small regional
government agency. One of the things they're considering is a facility
enabling visitors to the site to submit a form identifying their
interests and/or concerns. These visitors would then be mailed a monthly
newsletter.

We're assuming a maximum of 50 unique responders per month over a 3 year
period, so a possible max of 1800 responders.

My questions:

Would it be most efficient to have a connected database harvest the
email addresses? If so, designing that would be beyond my knowledge and
I'd have to subcontract that portion. What could I expect to pay someone
for that (realizing that the cost of the database software would also
have to be included)?

Would this number of responders be small enough to simply manually
transfer names and email addresses into a standalone database? If so,
what would then be the best method to do a group emailing? And, would it
be relatively simple to do a group emailing in HTML?

Thanks in advance for all of your suggestions.

Craig

 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      25th Jul 2004
If your site is hosted on a Windows IIS server and you can use ASP and Access, then this could be
accomplished using the FP database components with no additional cost involved.

I would suggest that you only send email in text format with a link to a newsletter on the site in
HTML or PDF format.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Craig Schiller" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Hi, all -
>
> I'm probably going to be designing the website for a small regional
> government agency. One of the things they're considering is a facility
> enabling visitors to the site to submit a form identifying their
> interests and/or concerns. These visitors would then be mailed a monthly
> newsletter.
>
> We're assuming a maximum of 50 unique responders per month over a 3 year
> period, so a possible max of 1800 responders.
>
> My questions:
>
> Would it be most efficient to have a connected database harvest the
> email addresses? If so, designing that would be beyond my knowledge and
> I'd have to subcontract that portion. What could I expect to pay someone
> for that (realizing that the cost of the database software would also
> have to be included)?
>
> Would this number of responders be small enough to simply manually
> transfer names and email addresses into a standalone database? If so,
> what would then be the best method to do a group emailing? And, would it
> be relatively simple to do a group emailing in HTML?
>
> Thanks in advance for all of your suggestions.
>
> Craig
>



 
Reply With Quote
 
Craig Schiller
Guest
Posts: n/a
 
      26th Jul 2004
Thomas -

Thanks for the response. Unfortunately, as I tried to imply, I'm
unfamiliar with both ASP and Access, and have no pressing interest in
becoming familiar with either. I don't think the organization currently
has a website, so providing them with one that's hosted on a Windows IIS
server shouldn't be a problem.

Your point is taken about sending email only in text format. However,
that doesn't answer my question about the most efficient way to harvest
names and addresses and then create a mass mailing list.

Thanks for your help so far.

Craig

"Thomas A. Rowe" wrote:
>
> If your site is hosted on a Windows IIS server and you can use ASP and Access, then this could be
> accomplished using the FP database components with no additional cost involved.
>
> I would suggest that you only send email in text format with a link to a newsletter on the site in
> HTML or PDF format.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Craig Schiller" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> > Hi, all -
> >
> > I'm probably going to be designing the website for a small regional
> > government agency. One of the things they're considering is a facility
> > enabling visitors to the site to submit a form identifying their
> > interests and/or concerns. These visitors would then be mailed a monthly
> > newsletter.
> >
> > We're assuming a maximum of 50 unique responders per month over a 3 year
> > period, so a possible max of 1800 responders.
> >
> > My questions:
> >
> > Would it be most efficient to have a connected database harvest the
> > email addresses? If so, designing that would be beyond my knowledge and
> > I'd have to subcontract that portion. What could I expect to pay someone
> > for that (realizing that the cost of the database software would also
> > have to be included)?
> >
> > Would this number of responders be small enough to simply manually
> > transfer names and email addresses into a standalone database? If so,
> > what would then be the best method to do a group emailing? And, would it
> > be relatively simple to do a group emailing in HTML?
> >
> > Thanks in advance for all of your suggestions.
> >
> > Craig
> >

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      26th Jul 2004
Craig,

The point is that by using the FP database components, in most cases you can avoid learning about
ASP and Access. Basically, you create a form, then under Form properties, select to have the form
submit it results to a database, then FP will create the Access database for you or if you really
don't want to use the FP database component, simply have FP write the form results to comma
separated value (.csv) text file. However using ASP and a database you could allow subscriber to
unsubscribe, update their email address or other info.

You could also consider using one of the following:

http://www.topica.com/solutions/index.html

http://www.microsoft.com/smallbusine...lb/detail.mspx

If you really want to use database driven function but avoid working with ASP and databases, drop me
an email with your phone number.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Craig Schiller" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Thomas -
>
> Thanks for the response. Unfortunately, as I tried to imply, I'm
> unfamiliar with both ASP and Access, and have no pressing interest in
> becoming familiar with either. I don't think the organization currently
> has a website, so providing them with one that's hosted on a Windows IIS
> server shouldn't be a problem.
>
> Your point is taken about sending email only in text format. However,
> that doesn't answer my question about the most efficient way to harvest
> names and addresses and then create a mass mailing list.
>
> Thanks for your help so far.
>
> Craig
>
> "Thomas A. Rowe" wrote:
> >
> > If your site is hosted on a Windows IIS server and you can use ASP and Access, then this could

be
> > accomplished using the FP database components with no additional cost involved.
> >
> > I would suggest that you only send email in text format with a link to a newsletter on the site

in
> > HTML or PDF format.
> >
> > --
> > ==============================================
> > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > WEBMASTER Resources(tm)
> > http://www.ycoln-resources.com
> > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > ==============================================
> > To assist you in getting the best answers for FrontPage support see:
> > http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> > "Craig Schiller" <(E-Mail Removed)> wrote in message

news:(E-Mail Removed)...
> > > Hi, all -
> > >
> > > I'm probably going to be designing the website for a small regional
> > > government agency. One of the things they're considering is a facility
> > > enabling visitors to the site to submit a form identifying their
> > > interests and/or concerns. These visitors would then be mailed a monthly
> > > newsletter.
> > >
> > > We're assuming a maximum of 50 unique responders per month over a 3 year
> > > period, so a possible max of 1800 responders.
> > >
> > > My questions:
> > >
> > > Would it be most efficient to have a connected database harvest the
> > > email addresses? If so, designing that would be beyond my knowledge and
> > > I'd have to subcontract that portion. What could I expect to pay someone
> > > for that (realizing that the cost of the database software would also
> > > have to be included)?
> > >
> > > Would this number of responders be small enough to simply manually
> > > transfer names and email addresses into a standalone database? If so,
> > > what would then be the best method to do a group emailing? And, would it
> > > be relatively simple to do a group emailing in HTML?
> > >
> > > Thanks in advance for all of your suggestions.
> > >
> > > Craig
> > >



 
Reply With Quote
 
Bob Lehmann
Guest
Posts: n/a
 
      26th Jul 2004
>> you can avoid learning about ASP and Access.

Until something goes wrong or until someone wants a tweak or feature.

I would never recommend using the built-in ASP / Access for a customer's
site - especially a government site.



Bob Lehmann

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:%23Qa7%(E-Mail Removed)...
> Craig,
>
> The point is that by using the FP database components, in most cases you

can avoid learning about
> ASP and Access. Basically, you create a form, then under Form properties,

select to have the form
> submit it results to a database, then FP will create the Access database

for you or if you really
> don't want to use the FP database component, simply have FP write the form

results to comma
> separated value (.csv) text file. However using ASP and a database you

could allow subscriber to
> unsubscribe, update their email address or other info.
>
> You could also consider using one of the following:
>
> http://www.topica.com/solutions/index.html
>
> http://www.microsoft.com/smallbusine...lb/detail.mspx
>
> If you really want to use database driven function but avoid working with

ASP and databases, drop me
> an email with your phone number.
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Craig Schiller" <(E-Mail Removed)> wrote in message

news:(E-Mail Removed)...
> > Thomas -
> >
> > Thanks for the response. Unfortunately, as I tried to imply, I'm
> > unfamiliar with both ASP and Access, and have no pressing interest in
> > becoming familiar with either. I don't think the organization currently
> > has a website, so providing them with one that's hosted on a Windows IIS
> > server shouldn't be a problem.
> >
> > Your point is taken about sending email only in text format. However,
> > that doesn't answer my question about the most efficient way to harvest
> > names and addresses and then create a mass mailing list.
> >
> > Thanks for your help so far.
> >
> > Craig
> >
> > "Thomas A. Rowe" wrote:
> > >
> > > If your site is hosted on a Windows IIS server and you can use ASP and

Access, then this could
> be
> > > accomplished using the FP database components with no additional cost

involved.
> > >
> > > I would suggest that you only send email in text format with a link to

a newsletter on the site
> in
> > > HTML or PDF format.
> > >
> > > --
> > > ==============================================
> > > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > > WEBMASTER Resources(tm)
> > > http://www.ycoln-resources.com
> > > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > > ==============================================
> > > To assist you in getting the best answers for FrontPage support see:
> > > http://www.net-sites.com/sitebuilder/newsgroups.asp
> > >
> > > "Craig Schiller" <(E-Mail Removed)> wrote in message

> news:(E-Mail Removed)...
> > > > Hi, all -
> > > >
> > > > I'm probably going to be designing the website for a small regional
> > > > government agency. One of the things they're considering is a

facility
> > > > enabling visitors to the site to submit a form identifying their
> > > > interests and/or concerns. These visitors would then be mailed a

monthly
> > > > newsletter.
> > > >
> > > > We're assuming a maximum of 50 unique responders per month over a 3

year
> > > > period, so a possible max of 1800 responders.
> > > >
> > > > My questions:
> > > >
> > > > Would it be most efficient to have a connected database harvest the
> > > > email addresses? If so, designing that would be beyond my knowledge

and
> > > > I'd have to subcontract that portion. What could I expect to pay

someone
> > > > for that (realizing that the cost of the database software would

also
> > > > have to be included)?
> > > >
> > > > Would this number of responders be small enough to simply manually
> > > > transfer names and email addresses into a standalone database? If

so,
> > > > what would then be the best method to do a group emailing? And,

would it
> > > > be relatively simple to do a group emailing in HTML?
> > > >
> > > > Thanks in advance for all of your suggestions.
> > > >
> > > > Craig
> > > >

>
>



 
Reply With Quote
 
Bob Lehmann
Guest
Posts: n/a
 
      26th Jul 2004
The most efficient way is the one that you have expressed "no pressing
interest in becoming familiar with". So, you can expect to pay $50 - $125+
per hour to have it done for you.

Bob Lehmann

"Craig Schiller" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thomas -
>
> Thanks for the response. Unfortunately, as I tried to imply, I'm
> unfamiliar with both ASP and Access, and have no pressing interest in
> becoming familiar with either. I don't think the organization currently
> has a website, so providing them with one that's hosted on a Windows IIS
> server shouldn't be a problem.
>
> Your point is taken about sending email only in text format. However,
> that doesn't answer my question about the most efficient way to harvest
> names and addresses and then create a mass mailing list.
>
> Thanks for your help so far.
>
> Craig
>
> "Thomas A. Rowe" wrote:
> >
> > If your site is hosted on a Windows IIS server and you can use ASP and

Access, then this could be
> > accomplished using the FP database components with no additional cost

involved.
> >
> > I would suggest that you only send email in text format with a link to a

newsletter on the site in
> > HTML or PDF format.
> >
> > --
> > ==============================================
> > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > WEBMASTER Resources(tm)
> > http://www.ycoln-resources.com
> > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > ==============================================
> > To assist you in getting the best answers for FrontPage support see:
> > http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> > "Craig Schiller" <(E-Mail Removed)> wrote in message

news:(E-Mail Removed)...
> > > Hi, all -
> > >
> > > I'm probably going to be designing the website for a small regional
> > > government agency. One of the things they're considering is a facility
> > > enabling visitors to the site to submit a form identifying their
> > > interests and/or concerns. These visitors would then be mailed a

monthly
> > > newsletter.
> > >
> > > We're assuming a maximum of 50 unique responders per month over a 3

year
> > > period, so a possible max of 1800 responders.
> > >
> > > My questions:
> > >
> > > Would it be most efficient to have a connected database harvest the
> > > email addresses? If so, designing that would be beyond my knowledge

and
> > > I'd have to subcontract that portion. What could I expect to pay

someone
> > > for that (realizing that the cost of the database software would also
> > > have to be included)?
> > >
> > > Would this number of responders be small enough to simply manually
> > > transfer names and email addresses into a standalone database? If so,
> > > what would then be the best method to do a group emailing? And, would

it
> > > be relatively simple to do a group emailing in HTML?
> > >
> > > Thanks in advance for all of your suggestions.
> > >
> > > Craig
> > >



 
Reply With Quote
 
Craig Schiller
Guest
Posts: n/a
 
      26th Jul 2004
Bob -

Thanks for the info, but how many hours would you ballpark?

Craig

Bob Lehmann wrote:

> The most efficient way is the one that you have expressed "no pressing
> interest in becoming familiar with". So, you can expect to pay $50 - $125+
> per hour to have it done for you.
>
> Bob Lehmann
>
> "Craig Schiller" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Thomas -
> >
> > Thanks for the response. Unfortunately, as I tried to imply, I'm
> > unfamiliar with both ASP and Access, and have no pressing interest in
> > becoming familiar with either. I don't think the organization currently
> > has a website, so providing them with one that's hosted on a Windows IIS
> > server shouldn't be a problem.
> >
> > Your point is taken about sending email only in text format. However,
> > that doesn't answer my question about the most efficient way to harvest
> > names and addresses and then create a mass mailing list.
> >
> > Thanks for your help so far.
> >
> > Craig
> >
> > "Thomas A. Rowe" wrote:
> > >
> > > If your site is hosted on a Windows IIS server and you can use ASP and

> Access, then this could be
> > > accomplished using the FP database components with no additional cost

> involved.
> > >
> > > I would suggest that you only send email in text format with a link to a

> newsletter on the site in
> > > HTML or PDF format.
> > >
> > > --
> > > ==============================================
> > > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > > WEBMASTER Resources(tm)
> > > http://www.ycoln-resources.com
> > > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > > ==============================================
> > > To assist you in getting the best answers for FrontPage support see:
> > > http://www.net-sites.com/sitebuilder/newsgroups.asp
> > >
> > > "Craig Schiller" <(E-Mail Removed)> wrote in message

> news:(E-Mail Removed)...
> > > > Hi, all -
> > > >
> > > > I'm probably going to be designing the website for a small regional
> > > > government agency. One of the things they're considering is a facility
> > > > enabling visitors to the site to submit a form identifying their
> > > > interests and/or concerns. These visitors would then be mailed a

> monthly
> > > > newsletter.
> > > >
> > > > We're assuming a maximum of 50 unique responders per month over a 3

> year
> > > > period, so a possible max of 1800 responders.
> > > >
> > > > My questions:
> > > >
> > > > Would it be most efficient to have a connected database harvest the
> > > > email addresses? If so, designing that would be beyond my knowledge

> and
> > > > I'd have to subcontract that portion. What could I expect to pay

> someone
> > > > for that (realizing that the cost of the database software would also
> > > > have to be included)?
> > > >
> > > > Would this number of responders be small enough to simply manually
> > > > transfer names and email addresses into a standalone database? If so,
> > > > what would then be the best method to do a group emailing? And, would

> it
> > > > be relatively simple to do a group emailing in HTML?
> > > >
> > > > Thanks in advance for all of your suggestions.
> > > >
> > > > Craig
> > > >


 
Reply With Quote
 
Murray
Guest
Posts: n/a
 
      26th Jul 2004
5-10 hours.

--
Murray

"Craig Schiller" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Bob -
>
> Thanks for the info, but how many hours would you ballpark?
>
> Craig
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to deal with null values in calculations in forms =?Utf-8?B?bWFybw==?= Microsoft Access Forms 2 31st Dec 2005 02:59 PM
need user-friendly way to deal with pictures and form =?Utf-8?B?c29pbGNvbjE=?= Microsoft Word Document Management 2 28th Jun 2005 07:45 PM
user.config deal Harry Simpson Microsoft ASP .NET 3 31st Mar 2004 03:10 PM
Oracle .NET driver / ODP.NET: how to deal with user defined types? Frans Bouma Microsoft ADO .NET 2 25th Sep 2003 08:50 AM
Re: Is this 181 GB drive on EBay a good deal or a bad deal? GMAN Storage Devices 0 24th Jun 2003 08:45 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:27 AM.