I have been fooling around with this code and everything works accept for inserting new records. Any ideas?

What kind of error message you get when you try to insert new records?

I get the following error in explorer: HTTP 500 - Internal server error.
If I comment out the insert statement it goes through the rest of the code fine or if I avoid the insert (by typing in an email address that is already present in the database).

Thanks

You are not telling the error message, probably you are seeing only "HTTP 500 - Internal Server Error" message.

Do this:

In Internet Explorer go to Tools -> Internet Options -> Advanced ( Tab ) -> Browsing: Show friendly HTTP error messages.

Uncheck this "Show friendly HTTP error messages" option.

Try running the newsletter script again, and this time you should see the real error message, and that is the error message that I want you to post here for me to analyze what may have gone wrong.

Thank you for your help. It is much appreciated. I figured out the folder my db was in was read-only, I felt stupid.

But I have another question. When I use the admin script to send an email. It loops through fine and sends the emails out properly until it gets to a bad email address. Then evidently it quits, because any valid email addresses following the bad one in the db do not receive the email.

Any ideas on this one?

Thanks again,
Ben

You'll have to use VBScript error handling like this:

<%
On Error Resume Next

' .. Put all the email code here e.g While...Wend

If Err.Number = 0 Then
  Response.Write "Email Sent"
Else
  Response.Write "Something went wrong : " & Err.Description
End If
%>

Hi I am a newbie to using ASP so please be patient. I have followed your instructions in the article but I am getting the following error message when trying to add a new email address:

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/test/mail_ac.asp, line 24

Line 24 of the code is as follows:
con.Execute sql_insert

I can't understand why this is happening and would be grateful for any help!

This error is because your DB does not have write permissions. Give that file Read/Write permission, and you'll be fine.