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 | |
11111 | abc@abc.com |
22222 | abc@amazon.com; aaa@amazon.com |
33333 | bbb@bbc.com, ccc@bbc.com |
Expected Outcome
Account Number | |
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
Solved! Go to Solution.
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