I have a function which produces an email for a specific contact, and I have a report which again is for the same specific contact. This function opens Outlook and enters the email data into the message body (derived from one Query), and it then attaches the report (derived from another query) to the email.

This routine works perfectly, however, it means I have to enter the Contact name into both InputBoxes. Is there a way to use...