Hi,
i want to do the following, from the table below i want to:
1-Filter per column C for unique values
2-Once filtered if its only "1" row, then put each cell on that row into a variable.
3-Once filtered if the results is more than 1 records, meaning the same email address has 2 or more records then grab all the range from A to E (range to HTML).
4- Paste the information in an Email (outlook app 2010).
5-Loop until column B hits a blank cell, which means its the end.
Table Example:
<tbody>
</tbody>
At the end, the following emails should be sent or display:
1- One email with 2 rows with all columns from A to E to test1@test.com in a range to Html.
2- one email with 1 row with all columns from A to E to test2@test.com in variable then paste them into HTML.
i need the VBA logic since all the examples i have been reading doesnt fit this exact way i want to do it.
Thank you so much for reading!
i want to do the following, from the table below i want to:
1-Filter per column C for unique values
2-Once filtered if its only "1" row, then put each cell on that row into a variable.
3-Once filtered if the results is more than 1 records, meaning the same email address has 2 or more records then grab all the range from A to E (range to HTML).
4- Paste the information in an Email (outlook app 2010).
5-Loop until column B hits a blank cell, which means its the end.
Table Example:
| Record ID | Data | Data | Data | |
| Record1 | test1@test.com | 1 | 1 | 1 |
| Record2 | test2@test.com | 2 | 2 | 2 |
| Record3 | test1@test.com | 3 | 3 | 3 |
<tbody>
</tbody>
At the end, the following emails should be sent or display:
1- One email with 2 rows with all columns from A to E to test1@test.com in a range to Html.
2- one email with 1 row with all columns from A to E to test2@test.com in variable then paste them into HTML.
i need the VBA logic since all the examples i have been reading doesnt fit this exact way i want to do it.
Thank you so much for reading!
