Subscriptions DB for a web site

[SmagO]

Hi all,

I am building a web site for a company and they need to have a page where users can leave their name and e-mail address. The company can then use the email addresses to send their newsletter to.

How should I go about this? A simple access db with an asp page can capture the e-mails, but then hwo do I go about turning the table into contacts that they can easily email?

Thanks

[buffer_overflow]

depends on how they plan on doing their mailing.

If they're going to send huge batches, you will need to write some sort of routine that

1. pulls all the email addresses out of access
2. use something like CDONTS to send out the email.

the EASY way (if you don't have a ton of recipients) is

1. pull all email addresses out of access
2. loop through it to create a long string delimited with a semi colon .. then paste this string into the BCC field in outlook before sending out the email.

[HackerNeo]

Is The Company wanting to personalise the Newsletter with the persons Name?

What Format is the Newsletter In RTF or HTML ?

Hope to hear from you soon

[SmagO]

Hi
its an RTF mail and yes, I would like to include their names.

Thanks in advance

[HackerNeo]

Ok then following may be slow but as far as I can see I may be the best course of action for you is to use CDO and construct the RTF Letter in a string to be EVal() by the asp page and sent to the contact but in order to do this you need to to a
do while note rsObj.EOF
//cdo code goes here//
Loop


I'll find my old cdo code and construct the cdo you need and post It later I hope this helps

[SmagO]

I will be super grateful if you could do that for me.

Many THANKS

[HackerNeo]

Need to know the operating System company for the right e-mail connctivity to use for you

Hope to hear from you soon

[HackerNeo]

If Company OS = 2yk +

Then here is the code

Set objEmail = CreateObject("CDO.Message")
objEmail.From = "Sender Address"
objEmail.To = "Client Address"
objEmail.Subject = "Server down"
objEmail.HTMLBody = "<h1>This is some sample message html.</h1>" 
objEmail.Configuration.Fields.Item _
    ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objEmail.Configuration.Fields.Item _
    ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = _
        "Your EXCHANGE Server"
objEmail.Configuration.Fields.Item _
    ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objEmail.Configuration.Fields.Update
objEmail.Send

If you need help getting it to integrate with your DB for sending let me know send me e-mail @ [email protected]

Hope this help you
Regards

[SmagO]

Thanks buddy, I will try this out....