Hello,
I am looking to create an email in VBA through excel that emails only the data associated with the same email address only once. .... For example with the following table:
<tbody>
</tbody>
I want to be able to email each person only once with the data points associated.
I have figured out how to email each line, however they will receive as many emails as there are rows, which would not be fun
If anyone knows how to solve my problem it would be greatly appreciated!!!
I am using Excel 2010
Thanks,
I am looking to create an email in VBA through excel that emails only the data associated with the same email address only once. .... For example with the following table:
Amount | Time | Person | |
3 | 14 | Tom | Tom@gmail.com |
2 | 200 | Tom | Tom@gmail.com |
4 | 6 | Tom | Tom@gmail.com |
7 | 2 | Chris | Chris@gmail.com |
99 | 200 | Matt | Matt@gmail.com |
2 | 9.6 | Matt | Matt@gmail.com |
29 | 2 | Steve | Steve@gmail.com |
33 | 45 | Steve | Steve@gmail.com |
44 | 46 | Sam | Sam@gmail.com |
<tbody>
</tbody>
I want to be able to email each person only once with the data points associated.
I have figured out how to email each line, however they will receive as many emails as there are rows, which would not be fun
If anyone knows how to solve my problem it would be greatly appreciated!!!
I am using Excel 2010
Thanks,
Last edited: