Construct a comma-separated email list that can be copied and pasted into the to, cc, or bcc field.

create_email_list.sh

# myfile.csv is a CSV export of a Google sheet. that contains name, email, and affiliation .
# The first three lines are headings and boilerplate. "-n +4" tells tail to only display line 4 and later.
# The cut command extracts the second column (email addresses) using ',' as the delimiter.
# tr transforms the newlines into commas to create a comma-separated list of only email addresses.
tail -n +4 myfile.csv  | cut -d ',' -f 2  | tr '\n' ','