I've been looking for a while everywhere and I can't find a real answer to this. I made a program that creates various reports based on excel data. They are daily reports. I want to put a button on my report to email these reports. However, I want to be able to select who I want to send it to using a form. I have a directory of names and emails, and that form feeds off of that data, and with that I want to be able to have Access link the e-mail to the person(s) who's name(s) is currently selected.
My problem is, since this form isn't directly on the report, I don't know how to make it e-mail the report that is currently open. How would I do this?
This is what the form looks like:
Where "Nombre" is where you select individual people by their name, "categorķa" is where you select a category and it sends it to those people in that category, and "oficina" is to send it to people by office.
I want to send it only to those selected, and make it so you can only send it to people using one listbox at a time.
PS: I want to use Lotus Notes 8.5