I have a report I have created in Access XP to show budgeted and actual revenue/expenses, broken down by VP, Administrator, and Department Head.
The report currently shows all departments, and I can use the sendobject macro to email (via MS Outlook/Exchange)this entire report in snapshot format to specified users.
What I would like to be able to do is email a report to Joe Schmoe, which only Joe Schmoe’s departments on the report. I am guessing this will be done by making my source query a Parameter Query.
I have changed the query over to a parameter query, and I can run a macro using the SendObject function…but I have to type in each individual name.
Now I have to deal with the fact that we have over 100 VPs/Admins/Dept Heads, and typing each name every time I want to run the report just doesn’t seem like a good use of time. I was hoping that I could use some type of distribution list with the Names and Exchange Aliases of each recipient?
Am I going the right direction here? Is anyone willing to help?