Extacting select rows to email

I have a situation where I have a report that I receive every week, that needs to be parsed by a value in column A, and copied and pasted into an email for distribution.

Location Values Values
001 $12,350 $12,000
001 $12,450 $13,000
001 $12,550 $14,000
002 $12,650 $15,000
002 $12,850 $16,000
003 $12,350 $17,000
003 $12,250 $18,000
004 $12,150 $19,000


I want to send an email to location 001, which has a unique email address, that includes all of rows for location 001. Then I want to send an email to location 002, which has a unique email address, that includes all rows for that location, and so on for each loaction. Can anyone help this newbie? I'm using Office 365.

Thanks!

Rob

the code below will filter the data by each email then send only that data

but your data has no addresses...you must add them (according to LOCATION?) ...
below it gets the email in col(F)

Please Login or Register  to view this content.