Extract Email Adresses

[howard]

I have names in Col A that is the same as the names in the address book in Microsoft Outtlook

I need a macro that will extract the email address/es in Col B based on the names in Col A


It would be appreciated if someone could assist me

 

[howard]

Also posted on link below


https://forums.windowssecrets.com/showthread.php/181822-Extract-Email-Adresses?p=1091668#post1091668

 

[GerryZ]

write some examples

 

[howard]

See some same data below as requested.


The items in Column A are manually typed but are exactly the same as the distribution group in Outlook called "Sales Staff", "Admin Staff" etc.

What I am looking for for code to extract the email addresses from outlook that matches the distribution list in Column B


Examples
A2: Sales Staff
B2: Ste@mac.com;pet@mac.com

A3: Admin Staff
B3: dav@mac.com;lau@mac.com;nig@mac.com

 

[Peter_SSs]

Since this is as much (or more) about extracting info from Outlook than Excel, I have moved the thread to a more appropriate forum.
Unfortunately in this forum, you can't use the HTML Makers so I have re-written your sample data.

(Hi Gerardo, hope you are well! Good to see you pop in here again - haven't seen you about for quite a while! )

 

[howard]

Hi Peter

Thanks for moving this to a more apprpriate forum


Please provide link to the forum

 

[Peter_SSs]

Please provide link to the forum

I don't know what you are asking. If you are reading this you are in the forum.

 

[howard]

Hi Peter


You mentioned in post #5 , that you haved oved the thread to a more appropriate forum, hence the reason for asking for the link.ly under


I now see that you have moved it under general. I was initially under the impression that you had moved it to another Excel forum on another Website

 

[Peter_SSs]

Ah, now I understand. No, just moved to the 'General Excel Discussion & Other Questions' forum within MrExcel.