Select Specific Outlook Email Within Excel

Hi,

I need a script to perform the following task:
1. Upon double-clicking a cell in Excel, a window opens for me to select an email from my active Outlook Inbox
2. After confirming my selection, extract and concate the selected email's sender and date & time of email into the target cell
3. Convert the selected email into pdf and save it in a local drive

I was able to find this https://support.microsoft.com/en-us/kb/240935 which identifies the selected email but it requires the user to select the email before executing the script.

I need the selection to be part of the double click of cell in Excel.

Thanks alot in advance!