creating mailing labels from a Numbers spreadsheet?

Question

RTE1953 Author

Level 1

4 points

creating mailing labels from a Numbers spreadsheet?

I'm trying to stop using MS Office. I can open my Excel spreadsheet of names and addresses in Numbers, but I have no idea how to do the function that MS calls "mail merge" to take each unique name/address and make mailing labels. For my holiday cards. Next year. Excel magically moves everything over so that I can print 30 name/address records per sheet of Avery labels.

Can Numbers make mailing labels from a spreadsheet?

iMac 27″ 5K, macOS 10.14

Posted on Jan 3, 2021 2:09 PM

Reply

Answer 1

Best reply

Barry

Level 9

59,867 points

Jan 4, 2021 2:17 PM in response to RTE1953

Fairly simple, actually.

Add a note ( e,g, "Dec card list" ) to the card of each person who is to be on the list,

Create a new Smart Group. Name it Dec card list

Set its rule to card contains: Dec card list

To add a person to the list: Edit the person's card. Add the key words,

To remove a person from the list: Edit the person's card. Remove the key words.

Regards,

Barry

Reply

Answer 2

RTE1953 Author

Level 1

4 points

Jan 4, 2021 6:29 AM in response to Barry

Thank you, Barry. I suspect I'd need to create a 'group' of people I send the holiday cards to, and then use that for the labels, since only some Contacts get the cards. Sounds like a steep learning curve; no wonder that most years I just revise the sheets of labels.

Reply

Answer 3

Barry

Level 9

59,867 points

Jan 3, 2021 7:52 PM in response to RTE1953

Probably, but it will take some tinkering.

You might try entering the names and addresses into Contacts, where printing mailing labels to Avery templates is somewhat easier.

Regards,

Barry

Reply

creating mailing labels from a Numbers spreadsheet?

Similar questions