VBA to export outlook email (individual email) to excel file with userinputs

[PresidentEvil]

Hi All,

Its been a while and I was hoping to learn more of VBA Coding. So here I'm with a request for VBA code to export outlook email (individual) to an existing excel file.

So here is what I'm wanting the code to do:

When I open an email in Outlook and press a hotkey (in groupmail inbox)., the macro should export the following data in an existing excel file name say 'test'. This file might be open or closed. But macro should be able to work if either of condition is met:
1. Column A - Current/Present Date
2. Column B - SubjectLine
3. Column C - Email Body
4. Column D - DATE (This date should be picked from a textbox wherein user enter the date. This text box should appear when hotkey is pressed)
5. Column E - Text (This text should be picked from a textbox wherein user enter the data [after 'date' textbox])
6. Column F - text - "Pending"
7. Column G - text (This text should be picked from a textbox wherein user enter the data [after column E textbox])

So to sumamrise, if I press hotkey on an email, a textbox should appear to collect data for Column D, F & G. Then once this data is filled by user, all these data along with email information must be inserted in the excel file. Once that is done save the excel file. This process should be done every time I press the hotkey.

I'll be really grateful if you could provide me with the code for this. I understand there are many code available online but that doesn't work as I'm wanting to. Please help.

Thanks.

 

[PresidentEvil]

Any solution?