You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Level 1

4 points

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

Top-ranking reply

Level 5

5,047 points

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

View in context

Similar questions