Anyone have a workflow to email selected rows of Numbers spreadsheet?

[FlowerFan]

I have the tedious task of emailing sales summaries to all 50 of our co-op artists every month.  Is there a workflow to handle selecting all the rows in Numbers for each artist, and then associating that with the correct email address from my artists Group in Contacts and then Mailing it to them in Apple Mail?

 

I've been looking at Automator and Services, but maybe I should dive into the Alfred Powerpack instead?  Any opinions?

 

Thanks for your time. 

[dfay]

I'd look at https://iworkautomation.com/numbers/index.html - this is definitely doable in Applescript & there is a lot of great instructional material and examples there.  Alfred can easily call the Applescript once it's set up but Alfred isn't necessary for this approach - you can run a script from Script Editor or save it to run stand alone.  

Edited February 7, 2015 by dfay