I'm trying to associate a row (containing email subject, from, to, and body) with the email addresses within it, provided the emails are in a list of contacts. So, it might look like this:
<tbody>
</tbody>
...where I'm trying to find the 'first address in email' & 'second address in email'.
The contact list could be in a separate sheet, if that makes it easier.
Thanks!
| Subject | To | From | Body | First address in email | Second address in email | Contact List | |
| Hi! | <johnny a=""> a@example.com</johnny> | me@mycompany.com | Hi! | a@example.com | a@example.com | ||
| Updates | b@mycompany.com | me@mycompany.com | Here are some updates from d@example3.com | d@example3.com | c@example2.com | ||
| Introduction | c@example2.com, d@example3.com | me@mycompany.com | C, meet d! | c@example2.com | d@example3.com | d@example3.com | |
| Fwd: question | me@mycompany.com | e@example3.com | I have a question | e@example3.com | e@example3.com |
<tbody>
</tbody>
...where I'm trying to find the 'first address in email' & 'second address in email'.
The contact list could be in a separate sheet, if that makes it easier.
Thanks!
