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
Bu iş için 14 freelancer ortalamada $115 teklif veriyor
Hi, I'm a VBA automation expert. I have good understanding in outlook VBA objects, calling from excel or other office files. We can fix the 1st and 2nd item quickly. Let's have a chat for more detailed discussion. Than Daha Fazla
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.
Email automation with VBA. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating fro Daha Fazla
Hello, 2 to 4 hours it would take. Do you want this macro code in xlsm or access file ? Lets talk about for more in details. Thanks, Ram
HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects similar to your requirement using VBA. I ca Daha Fazla
Hello, Please review my profile as I have the relevant skills and experience required for this project. I can start working right now. Kindly send me a message to discuss further for references, portfolio, and case Daha Fazla
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.
Hi! It's not a complex demand as you know. I have experience with VBA (+20 years working with similar processes), and I am starting in this platform, but I can give references off-line if you want me to. Honestly: I ca Daha Fazla