473,608 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Creating A Mailing List Using ASP

IC
Hi,

I'm building a website and I want to include a mailing list. I just
want a form where a user could enter their email address, so I could
send them more information. I assume that the best way to do this is
with ASP. Right now, I'm learning ASP by testing pages using Abyss
web sever with Active HTML. I have XP Home, so I can't use IIS. Here
are my questions:

1. Is ASP the best way to create a mailing list
2. Can I just use excel for the database - not access
3. How do I connect to the database. I've read about using ODBC, but
I think that would only work when the web server is on my computer. If
I got someone to host the site for me, I don't think that would work.
4. Is there an easy way to mail to the names in the database?

Hopefully I'm on the right track.

Thanks,
E
Jul 19 '05 #1
6 1799

"IC" <ip*******@yaho o.com> wrote in message
news:c0******** *************** ***@posting.goo gle.com...
Hi,

I'm building a website and I want to include a mailing list. I just
want a form where a user could enter their email address, so I could
send them more information. I assume that the best way to do this is
with ASP. Right now, I'm learning ASP by testing pages using Abyss
web sever with Active HTML. I have XP Home, so I can't use IIS. Here
are my questions:

1. Is ASP the best way to create a mailing list
This depends on how you want your users to sign up. The question isn't so
much is ASP the best way as much as it would be, "Is a Web site the best
way?" I'd say that's the most common or second most common way, the other
being a majordomo type of thing.

2. Can I just use excel for the database - not access
If you want, but why?

3. How do I connect to the database. I've read about using ODBC, but
I think that would only work when the web server is on my computer. If
I got someone to host the site for me, I don't think that would work.
Many hosts allow you to use database connections if they support ASP.

4. Is there an easy way to mail to the names in the database?


Not if your host doesn't allow you to schedule tasks on the server, which
they probably won't let you do if it's a shared plan. Have you considered
using a service that offers mailing lists instead of creating your own? It
doesn't sound to me that you're ready to create your own or willing to
invest in what would be needed to do it right. (I don't mean that in an
insutling way!)
Ray at work
Jul 19 '05 #2
If you are just now learning ASP, you may want to consider just starting
with ASP.NET. If you download Web Matrix, it comes with it's own web
server, so you wouldn't have to mess with Abyss. The .NET framework has
built in capabilities for email as well (provided you have an email server),
and probably would make interacting with a database easier. ASP would be a
fine solution for this too, if you are just learning (.NET is sometimes a
little overkill), but definitely, definitely don't use Excel for your
database (I'm an avid hater of people who write applications around Excel).
You can use access files .mdb, even if you do not have access installed
(though it is much easier for debugging if you do have it). If you don't
have access, yea, go ahead and use Excel. There are about a million
different faqs out there for how to connect to a database, if you use ASP
you'll need to study up on ADO. ASP.NET would use ADO.NET.

Have fun,
--Michael
"IC" <ip*******@yaho o.com> wrote in message
news:c0******** *************** ***@posting.goo gle.com...
Hi,

I'm building a website and I want to include a mailing list. I just
want a form where a user could enter their email address, so I could
send them more information. I assume that the best way to do this is
with ASP. Right now, I'm learning ASP by testing pages using Abyss
web sever with Active HTML. I have XP Home, so I can't use IIS. Here
are my questions:

1. Is ASP the best way to create a mailing list
2. Can I just use excel for the database - not access
3. How do I connect to the database. I've read about using ODBC, but
I think that would only work when the web server is on my computer. If
I got someone to host the site for me, I don't think that would work.
4. Is there an easy way to mail to the names in the database?

Hopefully I'm on the right track.

Thanks,
E

Jul 19 '05 #3
> I'm an avid hater of people who write applications around Excel

Ouch! I usually tend to merely laugh at them. :-)

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
Jul 19 '05 #4
IC
"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message news:<ee******* *******@TK2MSFT NGP12.phx.gbl>. ..
I'm an avid hater of people who write applications around Excel


Ouch! I usually tend to merely laugh at them. :-)


Thanks for your help. I don't have access, so that's why I wanted to
be able to use excel. I do want to do this the "right way" and I want
to learn how to do it myself. The site I'm building is very small...I
can't see the database having more than 100 or so email addresses.
All I really want is a simple form with an action url calling an asp
page. The asp code would write to a database - excel or access - and
have all the email addresses.
Jul 19 '05 #5
Yeah it's all funny until the boss man wants you to "work around it" because
they were sold on the presentation layer not the implementation.

"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:ee******** ******@TK2MSFTN GP12.phx.gbl...
I'm an avid hater of people who write applications around Excel


Ouch! I usually tend to merely laugh at them. :-)

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Jul 19 '05 #6
On 27 Jan 2004 12:37:51 -0800, ip*******@yahoo .com (IC) wrote:
I'm building a website and I want to include a mailing list. I just
want a form where a user could enter their email address, so I could
send them more information. I assume that the best way to do this is
with ASP. Right now, I'm learning ASP by testing pages using Abyss
web sever with Active HTML. I have XP Home, so I can't use IIS. Here
are my questions:

1. Is ASP the best way to create a mailing list
Almost never. :)
2. Can I just use excel for the database - not access
Yes, even though it's ugly. You could use just a text file as well.
3. How do I connect to the database. I've read about using ODBC, but
I think that would only work when the web server is on my computer. If
I got someone to host the site for me, I don't think that would work.
Most hosts will accept some form of database connection. A text file
wouldn't necessarily need a connection, just an open.
4. Is there an easy way to mail to the names in the database?


You're looking at using CDO or a component if you're using ASP.
Better would be a mailing list package for the SMTP mail server you
use. Might look at:

http://www.aspfaq.com/show.asp?id=2026
http://www.aspfaq.com/show.asp?id=2119

Jeff
Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
1949
by: Dave Moore | last post by:
Hi All, Is it possible to implement a mailing list using PHP?. I know I could maintain a list of emails addresses in a db and send mail to them through my website, but how can I get true mailing list behaviour where emails are sent to a particular address (like mailinglist@mydomain.com) and then distributed to all of the email addresses?. Ta, Dave
0
1366
by: Thomas Heller | last post by:
I have created a py2exe mailing list. This list should be used to ask for help using py2exe, and to suggest and discuss new features or other changes to py2exe. The list is public, posting is allowed even for non-members. The web page of the mailing list is: https://lists.sourceforge.net/lists/listinfo/py2exe-users
0
6369
by: Brian van den Broek | last post by:
Hi all, There have been a few posts over the last month or so expressing a bit of exasperation with the "rising tide of newbie's". (Or, more accurately, the rising tide of questions from newbie's not trying to follow ESR's advice.) A month or so ago (in a thread found here: http://tinyurl.com/5bj8j), I suggested that it might help the situation if there were a python.org wiki page that amounted to a "Welcome to the Python community;...
19
5407
by: Steve | last post by:
Can anyone point me to a primer for creating OCX controls in VB .net? In particular, I want to access a web service in a VB6 application (not an easy thing to do). So, if I can write an ActiveX control that accomplishes this in .Net, then I SHOULD be able to add the OCX component to my VB6 app and use it. Unless someone knows why this wouldn't work.... Any and all help is appreciated.
67
12485
by: Bob Powell | last post by:
To whom it may concern: I find the recent articles in various trade publications a little disturbing due to the lack of PostgrSQL mention. I continue to see articles about how IBM may be considering MYSQL for development an open_source web database. Why isn't PostgreSQL being considered or talked about by major industry giants? As a DBA I know that Postgres is far superior to MYSQL but if the industry directs it's energies towards...
4
2536
by: Andy M | last post by:
ALERT There is a person by the name of Mike Cox who's trying to turn this mailing list into a Big-8 newsgroup. Many of you know that this and most of the other postresql mailing lists are already gated to Google Groups and a small number of private news servers. If Mike Cox succeeds, this list will be available as a newsgroup on a great many more ISPs and NSPs, which could be a good or a bad thing. For one, e-mail addresses on this
4
2525
by: valeberry | last post by:
//Index.php <html><head><title>Mailing List Administration</title></head><body> <br> <center><H1>Mailing List Administration</H1></center> Send an email to a mailing list: <form method=post action="sendemail.php3"> <table><tr><td> <b>From Address:</b> <input type=text name="From" size="40" value=""> <br>
3
3147
by: Andy B | last post by:
I am working on a mailing list service for our company. One of the requirements is that when a person signs up for a mailing list through the website they have to activate their subscription through a link sent to them in an email. How would I do something like this? The db being used is sql server 2005 express.
2
2109
by: divyac | last post by:
I have developed an address book using php and mysql.I have all the contacts list in a table with check boxes.Now that i want to create mailing labels for the checked contacts...i.e.,the arrangements of addresses should be modified in such a way that there should be 5 addresses in a row of the table...I have done some coding but just dont know how to retrieve the checked contacts..Also..i have some problem in creating labels in which some...
0
8063
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8003
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8498
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8478
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8341
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
4025
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2474
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1598
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1331
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.