Hello Experts,
I am looking for some help from VBA experts. I hope someone can help. Thank you and appreciate your help in advance!
Requirement 1:
I need to have URL (say name: Send Email) in Column J (in cells J2, J3, J4 etc.). When I click that URL (say J3) it should take contents from that specific row (#3) and should generate an email like below
Email Subject: '[Contents from A3] + [Contents from C3] + Ownership Determination?'
Body: Hello Users,
Can you please check below and lets us which company owns the website? (Company 1 or Company 2?)
There should a table (A3 to C3)
Regards,
John Doe
Please check below screenshot for more details
Email Request_Image 1.PNG
Above is my requirement 1 and below is my Requirement 2
Once after I sent email and if users response back I want to capture that in a different sheet (Email Response). I want a Macro for a specific Folder in my Outlook (say Ownership Determination Response), whatever emails there in that folder needs to have those contents copied over to Spreadsheet (to sheet name 'Email Response'). Email Subject needs to copied to Column A which has free cell and Subject should be copied to its adjacent cell in Column B). Thanks in advance!
I am also attaching my SAMPLE spreadsheet.
Thanks
Bookmarks