Thanks so much for your reply.
The issue is that there’s different people I need to email every time, who don’t always fit in the same categories. So starting a new view or creating a formula each time, is as time consuming as having to go through all addresses one-by-one.
It’s a list of 80 freelancers that I email for different projects as they come in. At the moment I have to scroll down and copy/paste email addresses of suitable freelancers, one-by-one (sometimes up to 30 different emails).
I assume there’s no other way to select multiple non-continuous cells, unless I got back to using excel spreadsheets?
Ah, I see. I thought you had multiple Email fields per record, instead you have multiple records each with a single email.
If you’re linking your Freelancers to Projects, then you could have a Rollup/Lookup field that concatenates all their emails into a single cell to copy from. Otherwise, your solution would be the same ones already given above or going back to using a pure spreadsheet app.
As for making a View to copy from, you’d really only need one: If you make a Checkbox field and “check” all the appropriate Freelancers for your current batch, leave the View filtered or grouped by the Checkbox field. Then all the emails will line up adjacent to one another that you can copy. When you’re done, you can clear out the values for the Checkbox field. Day to to day, this would add about 30 seconds to the time it takes to do this compared to copying straight from non-contiguous cells as you would in Excel.
