Hello!
Here's what I'm trying to do, I have a table like this:
<tbody>
</tbody>
There will be many, many lines, and many email addresses. In this example, I just need a way to automatically filter both "a@bot.com" email addresses, and then copy cells 1 to 3 (Part, Desc and Rem), and paste it into an outlook email. I know how to do the latter bit, just need to figure out how to filter emails. The thing is, it's not a set list of emails, it will have new ones every time so I can't cycle through it.
Here's what I'm trying to do, I have a table like this:
Part | Desc | Rem | Plat | Price | |
TK800 | Test | Test | A | 9856 | a@bot.com |
BK890 | Test | Test | B | 6557 | z@bot.com |
KO983 | Test | Test | H | 478 | a@bot.com |
<tbody>
</tbody>
There will be many, many lines, and many email addresses. In this example, I just need a way to automatically filter both "a@bot.com" email addresses, and then copy cells 1 to 3 (Part, Desc and Rem), and paste it into an outlook email. I know how to do the latter bit, just need to figure out how to filter emails. The thing is, it's not a set list of emails, it will have new ones every time so I can't cycle through it.