Print Envelopes from a Numbers Spreadsheet with Mail Merge

Learn how to Print Envelopes from a Numbers Document using Mail Merge on the Mac, iPad, and iPhone.

With Pages not only can your merge your contacts from the Contacts app into a document, you can also merge contacts from a Numbers Spreadsheet! In this video I show you how you setup the Numbers document to prepare it for merging into Pages. I also show you how to map the fields form your spreadsheet to your Pages documents. I primarily show you the steps on the Mac, but I also show you how it works on the iPad and iPhone. See how Mail Merge works with Numbers in this video for Pages for the Mac, iPad, and iPhone.

CHECKOUT DANS TUTORIALS FOR MORE TIPS AND LESSONS

[susansoiree]

Thank you so much! You saved me days!!!

[MidnightSunConnection]

This was awesome! Thanks 😁 Bookmarked for future use.

[smartsheetguru]

Dan, Thanks so much for this tutorial!!!!

[jamesengelhart-co]

Thanks for the tutorial. I’m trying to print 5x7 envelopes but my iPad print option only allows 8 1/2 by 11 sheets of paper. Any suggestions?

[Psych]

This was great info, thank you. Can you tell us how we keep the sender’s information the same? I never saw you edit that section

[healthy-fit-happy]

Thank you. This helped me with my ABC license. 😉

[reekhavok]

You are awesome. Great tutorial. This would have been a nightmare to figure out from the manuals.

[rcush]

excellent instructional video and very easy to follow. I would like to know if you can make the printed address larger than what is printed?

[valerieburton]

I wanted to change the font and did so in Pages first but it did not copy over?? Suggestions? Just wanting to change names as they are for wedding invites. Great tutorial, thanks so much. Very easy to follow, thank you, thank you 😊 🥰

[roygokaywol]

Images: Can it be incorporated to this workflow? I tried adding images to the table it doesnt seem to work. Any help on this end would be appreciated.😊

[valerieburton]

Hmmm… dont see my comment 😮. Hope I didn’t leave it in wrong spot. I was asking about changing fonts. I changed the font on all the names in Pages but it didn’t copy over. 😢 I’m doing wedding invites and wanted to change font on just names. Also great tutorial and you also have the perfect voice for tutorials. Sounds familiar actually 🤔

[jimoberhaus]

How do I change the envelope to an invitation size 4x5 . I can change the size but the Recipient fields are too far to the right.

[marcwoodward]

How do you change your own return address? The highlight goes away soon as I change it.

[nathanniesen]

how do you import all the addresses from contacts over to numbers?

[JenniferCarroll-nz]

I've been searching for an app to mail merge in for 2 years. Google had one that was working for me then it stopped working. Didn't event think to use apple apps

[bethcasey]

Any suggestions for handling zip codes that start with "0" in Numbers? It is dropping the leading 0.

[jamesengelhart-co]

Thanks for the tutorial. I’m trying to print 5x7 envelopes but my iPad print option only allows 8 1/2 by 11 sheets of paper. Any suggestions?