dim recordsets not working.. got me????

[paulmcdonnell]

Hi guys

I'm using some code to send emails to alist of people. Nut in defining the code below I get the error message..

"Compile error"
"User defined type not defined"

Why is this ... has it something to do with the references ... if so what because I very unsure about references etc..

Hope you can help

paul


Dim rsEmail As DAO.Recordset

 

[DJN]

I think it could be a reference problem. Go to the modules tab, click on design, then tools. make sure that Microsoft DAO 3.5 Object Library is ticked.