I want to be able to e-mail the currently open report to a list of people using a combo box to select them. I want to add an "email" button to my reports, and have it open a form (see form attached).
Now, I have one table with the following columns:
Name, Email, Category, Office.
With the "Nombre" combo box, I want to be able to send it only to the selected people. With the "Categoria" combo box, I want to be able to send it to the people within the selected category(ies). With the "Oficina" combo box, I want to be able to send it to the people within the selected office(s).
I also only want to be able to use one combo box at a time.
Can someone guide me through how to do this? I need a dumbed version of a loop code to fill the "TO" field in the e-mail with the addresses of whoever's selected. I'm not very good with Access, and have looked everywhere. I've found some codes but have not been able to make use of them.
Now, I have one table with the following columns:
Name, Email, Category, Office.
With the "Nombre" combo box, I want to be able to send it only to the selected people. With the "Categoria" combo box, I want to be able to send it to the people within the selected category(ies). With the "Oficina" combo box, I want to be able to send it to the people within the selected office(s).
I also only want to be able to use one combo box at a time.
Can someone guide me through how to do this? I need a dumbed version of a loop code to fill the "TO" field in the e-mail with the addresses of whoever's selected. I'm not very good with Access, and have looked everywhere. I've found some codes but have not been able to make use of them.
Email to selected items in a combo box
0 commentaires:
Enregistrer un commentaire