MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Merge a Numbers Doc W/ Contact Details Into Pages To Create Maillabels?

I have a “contact list” in Numbers with people’s names and contact details, all in separate columns for firstname, lastname, zipcode, etc.

Question: I would like to create mailing labels. Can I import (mail merge) the data somehow into Pages and then format to match the label size and lay-out?

Thanks in advance. MacMost is fantastic!!

When I was still using MS Excel and MS Word, I used to be able to “import” the spread sheet data (first name, last name, etc) into the Word document to create either a maillabel document (to print individual labels) or a mail merge into a personalised newsletter. I haven’t found a way in Mac (Numbers and Pages) to achieve the same.
—–
Paul de Ridder (UK)

Comments: 2 Responses to “How Do I Merge a Numbers Doc W/ Contact Details Into Pages To Create Maillabels?”

    12 months ago

    Not easily, no. I have this video on how to do it, but it is not easy because Mail Merge is not a feature of Pages/Numbers. https://macmost.com/how-to-mail-merge-on-mac-with-pages-numbers-and-a-simple-script.html

    But in your case it could be just a matter of copying and pasting from Numbers into Pages, then working with the text to get it to fit onto labels. Have you tried that. I'm not suggesting it would be super easy. You'll need to roll up your sleeves to do some work. But it is probably the best route.

    Also, if you have the addresses in your Contacts app, then the Contacts app will print labels easily.

    There are also some apps in the App Store that will print labels.

    Paul de Ridder (UK)
    12 months ago

    Gary, you're a star. Thanks for telling me that Pages/Numbers does not feature a mail merge. Saved me a lot of time. I think the easiest way around the issue is: I will export the Numbers file to Excel and have my partner (who uses MSWord) produce the labels. Keep up the fantastic work!

Leave a New Comment Related to "How Do I Merge a Numbers Doc W/ Contact Details Into Pages To Create Maillabels?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)