Extract every Complete Name using just the email from Outlook to excel

**alexgoaga** · 06-22-2017, 09:59 AM

Hello,

I have a column (A) in an excel worksheet with endless e-mail addresses and i need to extract all the names using the outlook app in the column B

It's possible to create a link and extract all the required data and if the user is no longer available a text should appear to say something like "Not found" ?

Model :

*A column*	*B column*
*E-mails*	*Complete Names after the vba codes?*
[email protected]	Testing Person
[email protected]	Testing Person 1
[email protected]	Testing Person 2

Thank you for your time,
Alex

**Richard Buttrey** · 06-22-2017, 10:18 AM

Hi,

Are you asking whether it's possible to determine whether each email address is still valid?
If so you could only determine that by sending an email to see if it bounces back as undeliverable and I don't know whether Excel code could be written to do that although there may well be some other script that could.

I'll be interested to hear if that's the case.

**alexgoaga** · 06-22-2017, 10:28 AM

Not quite,
The first thing i need to solve is to convert the e-mail addresses from the column A into full names in column B (example the skype for business search) <--- this is the most important thing

The second thing if that was possible to search the e-mail pop-up someone. <--- not so important
for the second thing as an example i can give again the skype for business search engine : If an user searches an e-mail address , it returns blank if nothing is found.

**Richard Buttrey** · 06-22-2017, 10:58 AM

Re the first part. I'm sure that will be possible but I don't understand the rule that gets from A to B.

i.e. with

"[email protected]" in say A1 how does that become "Testing Person" in B1? If indeed that's what you want.

**alexgoaga** · 06-23-2017, 02:35 AM

yes , [email protected] is the email, after after the vba code runs , on B1 it should appear "Testing Person"

**cytop** · 06-23-2017, 02:48 AM

So you have a list of names for each email?

**alexgoaga** · 06-23-2017, 02:56 AM

unfortunately no, i have the e-mails in col A. i have to fill up col B with their names. If i had their names, i could easy use something like the find what = and get their name based on their e-mail very easy

**cytop** · 06-23-2017, 03:26 AM

Unless you have a list, for example in your Outlook address book, then there's no way to determine an addressee's name...

**alexgoaga** · 06-23-2017, 03:29 AM

i have the list of the user's email's (i've updated the table model above)

**cytop** · 06-23-2017, 03:53 AM

But you have no corresponding list (or access to such a list) to derive the actual name... or do you have a suggestion as to where the information can be found?

**alexgoaga** · 06-23-2017, 04:35 AM

is there any possiblitiy to make a link between the skype for bossiness search engine and excel?

**cytop** · 06-23-2017, 04:57 AM

I don't know and I don't use Skype so can't say.

Why don't you do what I would do, search for it. There seems to be a relevant thread on this forum dated 17 Nov 2015 but, as I don't use Skype, I can't comment on it.

http://www.excelforum.com/excel-prog...ne-status.html

Extract every Complete Name using just the email from Outlook to excel

LinkBack

Thread Tools

Rate This Thread

Display

Extract every Complete Name using just the email from Outlook to excel

Re: Extract every Complete Name using just the email from Outlook to excel

Re: Extract every Complete Name using just the email from Outlook to excel

Re: Extract every Complete Name using just the email from Outlook to excel

Re: Extract every Complete Name using just the email from Outlook to excel

Re: Extract every Complete Name using just the email from Outlook to excel

Re: Extract every Complete Name using just the email from Outlook to excel

Re: Extract every Complete Name using just the email from Outlook to excel

Re: Extract every Complete Name using just the email from Outlook to excel

Re: Extract every Complete Name using just the email from Outlook to excel

Re: Extract every Complete Name using just the email from Outlook to excel

Re: Extract every Complete Name using just the email from Outlook to excel

Thread Information

Users Browsing this Thread

Similar Threads

Extract Outlook Email text to Excel with VBA

Extract Content from file in email(outlook) to excel automatically (VBA macro)

Excel Macro to extract Email Details from Outlook specific Mailbox

Macro to extract information from outlook email and put into different columns excel

extract Location, email address of employee from Outlook GAL to excel based on Job Title

Extract Outlook email information to Excel

New to VBA and looking to add Macro to extract Outlook 2010 email content to Excel 2007 wb

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions