Getting Emails from Access...

[chhines]

I found a really neat URL on the web entitled, "How to Send E-Mail From MS Access using Outlook" and decided to test it with my database.

I’ve gotten so far with it, but I have an additional question and didn't get a response back from the site owner, so I wondered if maybe someone else knew how to do this.
Is there a way to pull the email addresses from an Access table or form based on the ones that are chosen or “enabled”?
For example, I have an access form that requires you to choose one person each from a series of combo boxes which have the employees only listed by their job title.
When a new project comes in, you select a person from each box to “assign” to the project. Then I display each assignee’s email address in a text box.
Now I want to take just the email addresses of those chosen for that project and put them as the recipients in an email to send.
I've attached the SendMail module as it works now, which I got from that article.
As it seems to work now, it includes all items from the list.
The "Myemailaddresses" code for the query pulls the person's name and their email address. I want to pull just specific ones and input them into the recipient field.
Thanks.

 

[ajetrumpet]

you have to manipulate the:

Mymail.TO

section of the code. that's the recipient field of the mail item object in outlook. for parsing and stuff, I think an upload of your database, or more explanation would be in order here. it's hard to understand without seeing what you're doing to give a full answer.