Extracting Email address from columns

[Masond3]

Good Afternoon Team, 

Hope your well, i need some assistance 

AIM: To extract every Email address from the "Email" Column associated to a given account number and display each email address as an different row

NB : Note that in some instances there can be more than one email to a given account number, this can be separated out either  by a "," or a ";"

Scenario 

Account Number	Email
11111	abc@abc.com
22222	abc@amazon.com; aaa@amazon.com
33333	bbb@bbc.com, ccc@bbc.com

Expected Outcome 

Account Number	Email
11111	abc@abc.com
22222	abc@amazon.com
22222	aaa@amazon.com
33333	bbb@bbc.com
33333	ccc@bbc.com

looking forward to your assistance 

Regards
Masond3

[SamSK]

you can use maill merge and if you want to extract email addresses , name and d phoen number from .eml or .msg files. Fom the out of office replies that come back from an email campaign, you can use this tool (776) Extract and mine leads from out of office replies of email campaigns - YouTube
www.Haileads.com