Firstly, I understand VBA enough to know what works and doesn't and how long this should take. Please quote accordingly. (2 hours for skilled VBA coder should be MORE than enough.)
I'd like code that takes an excel sheet, say with headings
Name, From:, Email
and resolves (exchange/ outlook application ) each From address to a properly formatted email address using relevant outlook application objects..
From address is in the format: /O=EXCHANGELABS/OU=EXCHANGE ADMINISTRATIVE GROUP (xxxxxxxxx)/CN=RECIPIENTS/CN=xxxxxxxxxxx-xxxx xxxxx
There may be hundreds or thousands of rows. Currently the solution is to copy the email addreses into an email and click "Check Name". - so I would like to be able to do the same functionally but from within excel.
SECOND ITEM. -
get name and from email address from [login to view URL] (or Body).
I'd like a VBA script that gets fed the email HTMLBODY or reply body and returns the Full name and Email.
From: Joe Blogs <joe@+[login to view URL]>
Sent: Wednesday, 21 April 2021 3:37 PM
To: 'blah blah blah'
Subject: This is the subject
14 freelanceria on tarjonnut keskimäärin $115 tähän työhön
Hi there, I can help you to get the 2 details from the outlook I am a Microsoft Certified Professional in Excel and VBA as an Expert. Regards, Karthick G.
computer information computer is an electronic macine which received data from user and after performing arithmetic and logical calculations it gives result to user as user wants.
Hello sir, I am an expert in excel work sheet, Microsoft outlook, Visual Basic and Visual basic for apps. I know well to these, So I am best for you.