how to email with vba from a form using cbo and list box selection

[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]

Just FYI to other members, this topic is related to this one:

related combo_box to get emails and send it with outlook

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...

www.access-programmers.co.uk

and also this one:

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

To the OP @ryprobg, there really is no need to post duplicate questions or threads. If you don't understand any of the suggestions given to you, you could ask for clarifications.

 

[ryprobg]

there is a differnce betwen the two db

 

[theDBguy]

there is a differnce betwen the two db

That may be, but isn't the problem the same? If not, please explain the difference. Thank you.

 

[theDBguy]

there is a differnce betwen the two db

Okay, I just downloaded you "new" file. You removed Query1 from it, even though I told you it's part of the solution to your problem.

I really think all three of your threads are about the same issue, so I am tempted to combine all of them.

 

[theDBguy]

there is a differnce betwen the two db

Here, I've added Query1 back for you. You should be able to use it to send out your email.

 

[ryprobg]

Here, I've added Query1 back for you. You should be able to use it to send out your email.

problem solved thank you @theDBguy
this is a great solution

 

[theDBguy]

problem solved thank you @theDBguy
this is a great solution

Does that solve the problem for all your three threads? Can I now combine them?