Newsletter wtih MS Access and FrontPage

[xfile]

Hi:

Can anyone point me where to find a tutorial for the following task?

We have stored user registration information in an Access database, and we
wish to develop a newsletter with FrontPage and import mailing list from the
Access database and to send out the newsletter with Outlook.

Many thanks in advance.

 

[MD Websunlimited]

Hi XFile,

Using ASP an CDOSYS / CDONTS you can send an HTML email that you've developed in FP.

See the ASP resources at http://www.websunlimited.com/resources.asp


--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
J-Bots Plus 2002 87 components for FrontPage
http://www.websunlimited.com/order/Product/JBP2002/jbp_help_dir.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible

 

[xfile]

Hi:

Thanks.

That part seems ok for me but how do I extract e-mail addresses from the
database and incorporate into the ASP HTML page with CDOSYS?

Thanks.

 

[MD Websunlimited]

See the ASP resource at http://www.websunlimited.com/resources.asp for instructions on using ASP and CDOSYS.

--
Mike -- FrontPage MVP '97 - '02
http://www.websunlimited.com
Need to use ASP in a FrontPage 2003 include component? Well you can with IncludeASP!
http://www.websunlimited.com/order/Product/IncludeASP/IncludeASP.htm
http://www.websunlimited.com/order/product/includeASP/includeASP.htm

 

[clintonG]

It sounds like your going to need one of two things:

Learn to write code before the first issue of the newsletter is
supposed to go out or hire somebody to write some code for
you.

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET csgallagher@ REMOVETHISTEXT metromilwaukee.com
URL http://www.metromilwaukee.com/clintongallagher/

 

[xfile]

Hi:

Thanks for pointing the resources and I will look into it.

Yes, I need to write codes and I guess that I am on the way of learning it.

PS: I also found out mail merge of Word 2003 might also do the trick, but I
am still experimenting it.

The difficult part for me now is to somehow extract the e-mail addresses
from the database and to incorporate into the newsletter. I know how to
manually insert 1-2 e-mail address into the ASP to send out.

Thanks and I will try it.

 

[+FarmerPickles]

Does it have to be done wit outlook? If your server supports CDONTS, it
would be easy to creat a mass emailing of a newsletter. You could creat it
in Word or whatever, and paste it into a form txt area, that would mail it
to everyone. If this is what you want.
Bammer

 

[xfile]

Hi there:

You're 100% correct. The reason that I tried Word was to find out if it can
import mailing list from a database file and I was amazed that it could
actually do that.

And it does not have to use Outlook nor Word and the server does support
CDONTS and CDOSYS.

But I am just a beginner of using ASP and CDOSYS/CDONTS. So far, I know how
to use ASP page to send form results to email (first by CDONTS and now
changed to CDOSYS) and database.

What I am trying to do further now is to using codes to extract mailing list
from the database file and some put it into the ASP newsletter and have it
sent out.

That is some kind of different tasks for me.

As you guys may already know, I am not an expert on programming. So I am
also trying to find out if those Office programs can help me to reducing
programming.

Anyway, thanks for the help from all of you and please let me know if you
happen to know where can I find tutorial materials for the tasks.

Thanks

 

[clintonG]

Nobody should use CDONTs anymore. The cdosys.dll library includes
methods for debugging and exception management, i.e. error control.
Changing to CDOSYS as you say you have was a good decision.
Now you must learn more about coding so you can take advantage
of it.

I've written my own ASP mail merge web application for e-commerce
clients. The application merged all sorts of data into the body of an
e-mail message. How to do so is very time consuming to explain.

At the moment you need to learn to write code that will access a
database and return a record set containing the e-mail addresses, write
a conditional branching logic statement that loops through the record
set to get each e-mail address, append each address to the send method
of the mail object, stir and repeat.

There are many, many, many, many, many, many, articles that
explain how to send e-mail via ASP. Use Google.

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET csgallagher@ REMOVETHISTEXT metromilwaukee.com
URL http://www.metromilwaukee.com/clintongallagher/

 

[xfile]

Hi:

Really appreciate your detailed feedback.

You are 100% correct about CDONTs. I learned that since the first day but
there are more CDONTs examples on the net even from MS KB. So I just used
those to help me to get started.

Then I finally got some examples from the net and have some time to revamp
the codes for using CDOSYS. Although I am not a technical expert, I can see
the speed of sending emails using CDOSYS is much faster than the old way.

Your explanations and directions are very good. It will help me to sort out
what types of examples are more appropriate for my tasks.

Thanks again for your kind and detailed explanations.

 

[clintonG]

I hope feeding you with the correct terminology and describing the
algorythm helps you find articles to learn from -- the same way most
of us have and which we continue to rely on ;-)

Make sure you check out the DevGuru Quick References [1].

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET csgallagher@ REMOVETHISTEXT metromilwaukee.com
URL http://www.metromilwaukee.com/clintongallagher/

[1] http://www.devguru.com/home.asp