Hi,Glad to hear you are making progress learning to debug your code, it is an essential skil that will greatly help you along your programming way...
I would suggest you use DAO.Recordset in your declarations to avoid ambiguity (there is another beast called ADO.Recordset and you don't want Access to get confused which one you want).
Can you please attach a copy of the EmailTBL table (or at least a screen shot)? As I explained a few times, it is not advisible to keep information that is not meant to be duplicated, such as WPassStr (the manually entered Windows password of the current user), the body of the email message and the "Registration" component of the email subject in a table that is meant as a storage for multiple recipient email addresses. You should really move those three fields to the GMailSettings table.
I noticed you also lost along the way the vMsg variable, it is not set anywhere but you do pass it to Colin's CDO function. Try to go over the code I uploaded earlier (use the text attachment as it is indented much better than the one posted with the code tags).
Yes, I am slowly getting there, I just dont know why I am feeling so using VBB
Yesterday afternoon I wanted to add a recipient from another control to the CC.
I did not want to add it incase it messes up my code
But I did it never the less and it worked just fine, suppose it wasnt that a big of a change
I will be moving the password to the gmail settings tbl this morning
I still want to make the additional change where the password being entered is masked with an * but I suppose that is a project at a later stage
I have one issue with the ProjectLeaderMail i added, what if it is blank or N/ A to this mail? it will give me an error
Below is the EmailTbl
I need to thank everyone for the assistance, much appreciated, I was very chuffed when the email was delivered successfully.