I have a bunch of users generating Excel reports out of Access. When too many people do it at the same time, things bog down. So I want the "Launch" button to send the requests to a "Queue" table. That table will store the desired report and the user ID. When the report is done and saved I want the program that is managing the queue to send them an email telling them it is done.
The email does not to be fancy or have attachments, so the simplest method will be best. But the "Sendobject" method merely launches Outlook with the desired data populated. I want it to SEND.