Print Envelopes from a Numbers Spreadsheet with Mail Merge
Вставка
- Опубліковано 14 лип 2024
- 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
▶︎ Dan’s Tutorials - www.danstutorials.com - Наука та технологія
Very helpful! Thanks!
This was awesome! Thanks 😁 Bookmarked for future use.
Glad it was helpful!
Dan, Thanks so much for this tutorial!!!!
Thank you. This helped me with my ABC license. 😉
Glad it helped!
Thanks Dan! Very easy to follow!
Glad to help!
You are awesome. Great tutorial. This would have been a nightmare to figure out from the manuals.
Glad to hear I was able to help! 😊
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?
Great and simple tutorial. Thank you!
Glad it was helpful!
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
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.😊
Thanks!
Thank you! Glad to hear I was able to help!
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?
Thanks! I believe you can. It's just text in Pages, so make the text larger in Pages and it will make the labels larger. Hope that helps!
Thank you for the quick response and yes it worked!!1
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 😊 🥰
how do you import all the addresses from contacts over to numbers?
How do you change your own return address? The highlight goes away soon as I change it.
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
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 🤔
Any suggestions for handling zip codes that start with "0" in Numbers? It is dropping the leading 0.
to add a 0 first type a single quote for example '03103
Another option is to format that cell as text. 😊
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?
🤔 I just looked on my iPad and I can print to 5x7. I did have to select my printer before I saw it. Also I am using iPadOS 17. Are you using the latest iPados?
Hi Dan, Yes I have iPad OS 17.1.1. Maybe it’s my printer I have an older model HP Office jet pro 8610