Dynamic Emailing

[theskyscraper1]

Hi,

Say I have this list:

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

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 1@hotmail.com (A1:B8) to 1@hotmail.com -> Count 2@gmail.com (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 damn appreciated. Thank you.

[AliGW]

The forum rules do not permit duplicate threads. Thread closed. Continue here, please: https://www.excelforum.com/excel-pro...constants.html

The forum rules are here: https://www.excelforum.com/forum-rul...rum-rules.html