related combo_box to get emails and send it with outlook

[ryprobg]

hello programmers
i have a mini form used to send emails to two person ( nom_hc) listed in (resp_acc) with emails ( email_hc)
in the form the user should select in cbo1 person1 and in the cbo2 person 2 and he will get emails in two listboxes below and record it in t_dci table source of the form.
the target is send email to those persons selected in the form
to : email1 & email2
subjet :""
body : ""
in the atachements db ..thank you for help
login : admin
pass : 1234

 

[theDBguy]

Hi. Is this related to your other thread?

get listbox values from combobox multiples selection

in this db a want to get the emails in listbox from selectin combobox multiple choises. how can i get it into table (t_dci) automatiquely thank you for help me. db in the attachements below login : admin passe :1234

www.access-programmers.co.uk

 

[ryprobg]

Hi. Is this related to your other thread?

get listbox values from combobox multiples selection

in this db a want to get the emails in listbox from selectin combobox multiple choises. how can i get it into table (t_dci) automatiquely thank you for help me. db in the attachements below login : admin passe :1234

www.access-programmers.co.uk

yes i try to solve this problem query1 not work

 

[theDBguy]

yes i try to solve this problem query1 not work

Can you please explain why Query1 doesn't work? If you're expecting Query1 to store the email data in the t_dci table, I told you that storing redundant data (storing information already stored in another table) is not a recommended approach.

 

[ryprobg]

ok : how i can get emails for selected persons to use it in macro to send email to this persons
as auto generated email
make a button to run macro
help me plz

 

[theDBguy]

ok : how i can get emails for selected persons to use it in macro to send email to this persons
as auto generated email
make a button to run macro
help me plz

You would use Query1 to send the email in your macro. I prefer to use VBA, so I can't really tell you what that macro might look like. You might also use the DLookup() function or the equivalent macro action to get the email addresses from Query1.