Dynamic Ranges

Hi,

Say I have this list:

File Number Order Age (Hours) PT Search Vendor Email
10039687WA TEST 145.66 [email protected]
10040529WA TEST 107.57 [email protected]
10040533CA TEST 107.52 [email protected]
10040968CA TEST 90.77 [email protected]
10040969CA TEST 90.74 [email protected]
10040971MI TEST 90.71 [email protected]
10041074CA TEST 88 [email protected]
10041463CA TEST 71.63 [email protected]
10040534NJ TEST 107.49 [email protected]
10040535WA TEST 107.46 [email protected]
10040536AZ TEST 107.44 [email protected]
10040538CA TEST 107.41 [email protected]
10040540TX TEST 107.38 [email protected]
10040965CA TEST 90.8 [email protected]
10040957TX TEST 90.92 [email protected]
10040959CA TEST 90.89 [email protected]
10040961CA TEST 90.85 [email protected]
10040963WA TEST 90.82 [email protected]
10041466CA TEST 71.58 [email protected]
10041467CA TEST 71.54 [email protected]
10041469MI TEST 71.5 [email protected]
10041473OR TEST 71.41 [email protected]
10041475TX TEST 71.38 [email protected]
10041052WA TEST 88.75 [email protected]

The email addresses are always changing and the file numbers associated with the email address are always changing.

Is it possible to have this as a range and send one email that includes all file numbers/information associated with that email address? So kind of like dynamic emailing.

Count [email protected] (A1:B8) to [email protected] -> Count [email protected] (A9:B15), etc. And the email is every changing, so I simply want it to identify a difference in a column, create a range, email range, find next difference, create range, email range.

I'm not having any luck finding anything similar to what I want so far.

Any help is so much appreciated. Thank you.