SendKeys Or Macro For "Right-click And Paste"

In short, my goal is to automate the function that Generates a Report, saves it as an Adobe PDF file using a "selected" file name. The selected file name is the name of the project (which is included as a datafield) in my primary tabel ( a linked Excel table). There maybe an easier way than the path I have chosen, if so please let me know.

The following provides a little more detail as to what I've done and what my problem is:

As noted above, my primary table is a linked table (Excel). There is datafield in that table that has the project code (and this is the name I want my PDF file to be). As a result, I created a new query in Access to query this project code. As a result, in my Generate Report macro, I open this query and then use the SendKey function to copy the datacell (i.e., project name) so I use this later to paste. My macro proceeds with opening my Primary Report and then "print" the file. Since I've selected Adobe PDF as my default printer, it will print to a file. As a result, the "Save PDF File as" menu pops up and the file name (Access name of the Report) is highlighted. However, my SendKey command to paste the project name does not work. When the "Save PDF File as" menu is up, the primary menu (ie., that has File, Edit, View, etc.) is inactive and my sendkey command will not process. However, at this point the mouse is still active and I can manually right-click the mouse and select paste for it to work.

The question is --- is there a way to perform the right-click and paste in a Macro or SendKey function. I don't see a SendKey command that invokes the right-click.