Stuck on sending Email via Access

[myzer92]

I'm stuck. What I have is a Address book in Access that has an addition to addresss fields is an email field and a catergory field. I have my catergory field filter done in many Queries. What I need to do is when I run a Query and find everyone in a particular Category then I need to send those email address into a new mail message so I can send an email to only those individuals. Hopefully that made sense. I'm stuck on how to go about doing this. Any help is greatly appreciated!!!!!

 

[etsoft]

if your qeury is showing you the right number of records, take a look at the SQL code and copy it.
In a form you can create a button which is having the following code

dim rcs as recordset

set rcs = CurrentDb.openrecordser("your copied SQL  code , you need te change the " into '     . ")

do until rcs.eof

docmd.sendobject command with the nescesary parameters, look in the help.

rcs.movenext
loop

rcs.close
set rcs= nothing

Of course you will need more things , like a subject etc.