Hi,
I would like to know how to check if an email already exist and skip adding a new record.

please advise

This is my code;

Sub addEmail()
MyEmail = Trim(MyConfig.AttributeGet("email"))
MyNewsletter = Trim(MyConfig.AttributeGet("newsletter"))
If MyEmail <> "" And MyNewsletter = "yes" Then
firstN = Trim(MyConfig.AttributeGet("firstname"))
lastN = Trim(MyConfig.AttributeGet("lastname"))
dbA.Open "users",dbConnection,3,3,2
dbA.AddNew
If firstN <> "" Or lastN <> "" Then dbA("name") = firstN & " " & lastN
dbA("email") = MyEmail
dbA("checkbox") = MyNewsletter
dbA.Update
dbA.Close
End If
End Sub