Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Posted on Aug 27, 2020 10:50 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 27, 2020 1:12 PM

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


1 reply
Question marked as Top-ranking reply

Aug 27, 2020 1:12 PM in response to snicklos

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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.