editing addresses to print on labels

I am printing labels for holiday cards. I want to send to the XX Family instead of to the individual's name. For instance instead of going to 'John Smith' I want it to go to 'The Smith Family'. Is there a way to do that? Thanks.

MacBook Pro 16″, macOS 15.1

Posted on Dec 20, 2024 1:19 PM

Reply
Question marked as Top-ranking reply

Posted on Dec 20, 2024 1:26 PM

Here's what I do. Open the Contacts app on my Mac and also open a blank Numbers spreadsheet. Select all contacts and drag them to Numbers. Manipulate them as desired in Numbers (e.g., create a column with a formula that is something like: = "The" + Last Name + "Family" (where Last Name refers to the last name field from the contacts data)).


I then use Numbers File menu > Export to export the spreadsheet to an Excel format. I print them using Avery Design and Print Online which is free, powerful and easy to use. It has an option to import the Excel spreadsheet data. See: https://www.avery.com/software/design-and-print/

Similar questions

1 reply
Question marked as Top-ranking reply

Dec 20, 2024 1:26 PM in response to Jeffmatusow

Here's what I do. Open the Contacts app on my Mac and also open a blank Numbers spreadsheet. Select all contacts and drag them to Numbers. Manipulate them as desired in Numbers (e.g., create a column with a formula that is something like: = "The" + Last Name + "Family" (where Last Name refers to the last name field from the contacts data)).


I then use Numbers File menu > Export to export the spreadsheet to an Excel format. I print them using Avery Design and Print Online which is free, powerful and easy to use. It has an option to import the Excel spreadsheet data. See: https://www.avery.com/software/design-and-print/

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

editing addresses to print on labels

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