Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chrissy
Starting Member
17 Posts |
 Posted - 2002-07-14 : 01:01:56
|
| Hey All,I work for a company that has a newsletter list with approximately 20,000 subscribers. They are looking for a new newsletter-sending solution and have asked me to look into it.I'm also working on the e-commerce part of their site and users from there will also tie into the user table for the mailing/newsletter list.I've decided that I will probably use SQL Server's ActiveX-invoking capabilities to send the newsletter. CDONTS may do, but I'll may go with JMail. If anyone sees a huge problem with this (SQL+COM), please let me know. They (small, 15 person company) have a dual PIII 1.x gigahertz dedicated sql server that will be doing the job.My biggest hurdle will probably be maintenance of dead email addresses. I was thinking this..On the reply-to, put the SQL Server's MAPI mailbox. If anything bounces back it will land in that mailbox and I can use SQL Server's capabilities to parse through those e-mails and update the database to remove the user from the newsletters.Which brings me to this question: Should I use xp_readmail or, since it is an exchange server, activeX within SQL to read? I have not used xp_readmail before so I'm not too sure if it will do what i need.Wow, this is encouraging. I just looked at a newsletter that MS sent me and the X-Mailer is "Microsoft CDO for Windows 2000". I also see that SQLTeam.com is using AspEmail. How are you doing maintenance, graz?Thanks much for any responses..Edited by - chrissy on 07/14/2002 01:02:50 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-07-14 : 02:15:39
|
| I've used ASP email for stuff similar to that, and I've had good success. I'm thinking that ASPEmail is slightly more high end that Jmail if I remember correctly.Michael<Yoda>Use the Search page you must. Find the answer you will. |
 |
|
|
chrissy
Starting Member
17 Posts |
Posted - 2002-07-14 : 04:07:47
|
| wow, and its free. Thanks much. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-07-14 : 12:42:33
|
| I just have an ASP page that sends messages. SQL Server isn't really involved except to provide a list of names. My processing of bounces is a horrible manual process. That's one of the things I'm looking to improve one of these days.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-07-14 : 13:50:08
|
| I've used ASPEmail to send newsletters for my site's subscribers. It works great and it even has a queueing functionality. So, all you need is a HTML form that contains the subject and message (can be pulled from the database as well) and an ASP page that reads all the email addresses from the database and sends the email out.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
chrissy
Starting Member
17 Posts |
Posted - 2002-07-14 : 15:50:41
|
| Thanks for the replies. graz, i'll let you know how my sortage goes.Vyas, i've used your site many times in the past, thanks for making all that info available. |
|
|
|
|
|
|
|
|
Newsletters within SQL Server