Create an email list from a column in a numbers spreadsheet
How do you create an email list from a column in a numbers spreadsheet
MacBook Pro 13″, macOS 10.14
How do you create an email list from a column in a numbers spreadsheet
MacBook Pro 13″, macOS 10.14
I think this is what you are asking for.
If you have a list in A of emails, and want to use them all in the To of an email out....
You can use a concatenate Function to make a long string with ; between each one. (change this for your email programs settings, some use a comma)
You Make B1=A1
Then in B2 enter this =Concatenate(B1, ";", A2)
Fill this down to your last cell in B, copy that last result in B and paste into your email FROM box.
This might be way off base, but its a try and might help someone else at least learn how to use concatenate. :)
thanks
Jason
I think this is what you are asking for.
If you have a list in A of emails, and want to use them all in the To of an email out....
You can use a concatenate Function to make a long string with ; between each one. (change this for your email programs settings, some use a comma)
You Make B1=A1
Then in B2 enter this =Concatenate(B1, ";", A2)
Fill this down to your last cell in B, copy that last result in B and paste into your email FROM box.
This might be way off base, but its a try and might help someone else at least learn how to use concatenate. :)
thanks
Jason
Create an email list from a column in a numbers spreadsheet