Hello and thanks so much in advance for any suggestions/help.
I'm trying to manage about 200 bouncebacks from my firm's newsletter. To make the updates in our CRM tool, I need to isolate the email addresses of every bounced email and get them into one cell. So I exported the bouncebacks to Excel, and the text of the bounced email is in one cell in one column.
I noticed that bounced emails are returned with varying text, but most have a single common denominator -- somewhere in the text of the bounced email the email address will be found between the characters "<" and ">". For example: "Your message to <name@company.com> was not delivered."
I think I need to use the find and replace function to isolate the email and replace everything else. I thought [~<*~>] would work, but it doesn't. I've also tried it in 2 steps: first replacing everything before the < and then everything after it, but it doesn't work all of time.
Does anyone have any ideas? Thanks again for your help!
I'm trying to manage about 200 bouncebacks from my firm's newsletter. To make the updates in our CRM tool, I need to isolate the email addresses of every bounced email and get them into one cell. So I exported the bouncebacks to Excel, and the text of the bounced email is in one cell in one column.
I noticed that bounced emails are returned with varying text, but most have a single common denominator -- somewhere in the text of the bounced email the email address will be found between the characters "<" and ">". For example: "Your message to <name@company.com> was not delivered."
I think I need to use the find and replace function to isolate the email and replace everything else. I thought [~<*~>] would work, but it doesn't. I've also tried it in 2 steps: first replacing everything before the < and then everything after it, but it doesn't work all of time.
Does anyone have any ideas? Thanks again for your help!