search and email

[Lau]

Hi there,

I am setting up a database at the moment. I do not have a lot of experience with Access but up to know everything was alright .

I don't know if it is at all possible...but I would like to be able to find out who has a yes in a "yes or no" field and than that it shows me the email addresses of the people that have a yes there....does that make sense...I hope so.

Ok if that is possible, the second thing I want to be able to do is to email those persons that have a yes.

I have understood by now I will need codes and everything. Problem is I don't know anything about creating codes...so would be great if someone can explain that to me. And is it right I put those codes into a new module?

I hope this all makes sense and that someone will be able/willing to help me.

Thanks in advance!

 

[SamDeMan]

i am assuming you know how to create a query. so create a query save it, and then you can go to Macros and start a new one. the action will be "SendObject" and then you will see all the parameters for email.

sam

p.s.
i would help you with the VBA, but i have no clue what you are doing, what you DB looks like, and you may need to read a bit about VBA before doing a project like this.

sam

 

[Lau]

Thanks

Thanks I guess I can figure out the email thing now...

What exactly do you need to know about my database??