Це відео не доступне.
Перепрошуємо.
How To Use Mail Merge With Pages On a Mac
Вставка
- Опубліковано 18 сер 2024
- macmost.com/e-... A new feature in Pages 12.1 is the ability to create envelopes, letters, invitations and other things by merging address data from the Contacts app or a Numbers spreadsheet.
FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
▶︎ UA-cam - macmost.com/j-y... (And hit the 🔔)
▶︎ UA-cam Email Notifications - macmost.com/ytn ⭐️
▶︎ MacMost Weekly Email Newsletter - macmost.com/ne... ✉️
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/pa... ❤️
00:00 Intro
00:40 Envelopes From Contacts
03:53 Letter WIth Contacts
04:41 New Invitations Templates
05:19 Using a Numbers Spreadsheet
07:31 Custom Templates
09:40 Flash Cards Example
#macmost #mactutorial
Gary, you are so the MAN I let all ads play during your videos so you can get all revenue that you deserve. What you have done for the MAC/apple community is amazing. I have saved so much by not spending on endless third-party apps and have used what is already baked into Apple products that are not widely known. But thanks to you I am officially a MAC power user. Thank you for your wonderful videos.
Back here two years later as a reference. What a great resource this channel is.
Thanks for the tips. You CAN use all the field names from a spreadsheet by selecting Add Mail Merge Field and then clicking Add From Spreadsheet.
In your flash card example, you could have selected as field names "Question" and "Answer" from the Add From Spreadsheet dialog.
Interesting!
@@macmost Maybe do a follow-up video showing folks this feature.
Gary, I have been trying to do my Christmas cards for years and just found out Apple has mail merge back. So rather than waiting til December and get frustrated on not being able to figure it out, I decided to try it today. Apple's instructions are so bad, so I looked up UA-cam videos and came across yours. Thank you, thank you, thank you. It still took me longer than I expected to figure it out, but I'm sure once I get used to your video style, I'll be much better. Now I get stop using my husbands' Windows computer which I hate for Mail Merge. I'll be tuning in regularly now to see what else you can teach me. thanks again.
I have been waiting for this feature for years! Thanks for bringing it to our attention, Gary! An excellent video as usual!
How I love UA-cam! How I love your presentation. Could not have done it without you (mail merge)… you speak quickly so I had to replay a few times, but I got there. Thanks so much.
Hi Gary. Another great video explaining a rather complex subject that can produce simple and effective results. You make me realize that a lot of the software I used to pay for can be done natively from within Mac. This is really valuable, both literally and figuratively. You’ve saved me a ton of money. Thank you so much!
Thanks for doing this video Gary. Pages desperately needed this features.
Thank you for sharing this information. I finally got everything right and I am ready to print our monthly newsletter with addresses merged in!
Great video, most useful. The formula you created for the address field was completely new for me. I need to work on my Numbers skills.
I wonder why it took them all this time to bring it back. Thank you for a great video as usual.
Thank you SO much for this video! We were able to take data from a spreadsheet of application questions/submissions and populate it in a way more readable document.
So thrilled to finally have mail merge capabilities other than having to purchase Word/Excel! Thank you for your excellent video. I would like to be able to create a sheet of labels from an inventory worksheet - each label will have different information. I've tried, will have to try again to see where I'm going wrong.
I don't think you can use this to make a sheet of labels as it is meant for one or more pages per name. For labels from a worksheet, maybe consider one of the many label printing apps that are in the App Store to make it easy.
@@macmost Thank you - I was beginning to think that. I’ve used Avery online but I hate going out there - I’ll check and see what apps there are.
Use Contacts App to create labels. The labels function is in Contacts' Print, with some degree of formatting available, even add graphics.
@@peterbreis5407 I have an inventory sheet of thousands of items and as I add new items, I’d like to print labels. Can’t see any way that contacts would work for this. I’ve gone back to Avery online. But thanks.
@@lyndaj2759 That is a different usage and I understand why you need it.
A database might be more appropriate, so you would be able to better check for duplication and narrowed searches/reports.
Thank you for illustrating how to do this. Your directions worked. Merging from the Contact List was buggy. Dragging a card into a Group is not flawless. I had to verify that the Cards indeed made it into the Group, which was time consuming. Merging from a Spreadsheet is probably the better choice.
Man, your videos are so good! And I mean all of your videos!!!👍⭐👍⭐👍⭐👍⭐👍⭐👍⭐👍 Thx very much
A very useful and informative video tutorial today! Thank you, Gary! 👏🏻❤️
Every time I see you doing Numbers, my jaw drops 🙌🏻 I've learned so much from your videos, you are the best!
Awesome! Thank you!
Another great video thanks Gary. Could I use this method to print adhesive labels?
No, since this is a one-entry-per-page thing. Use label printing software, the Contacts app, or a Pages template to do that.
Great function that at last came back to Pages! Thanks for you tutorial. 👍
Thank you so very much! I watch your videos as soon as they come out and this one will help me a great deal!
Mail merge! Finally! And thank you so much for the wonderful clear explanation!
About time too! I can’t understand why they removed this from a much earlier version (or am I mis- remembering?). It’s an essential tool for word processing.
It was in Pages '09 and it worked very well.
@@peterbreis5407 that’s right! I remember using it, saving docs from later versions to 9 to be able to do a merge.
Learning how to mail merge on Mac has been a challenge. Specifically trying to figure it out in Word, so thank you for this video. Will pages allow me to send an email like this, or can it only be used to create letters etc.
Hi there, I watched several video’s and I find each video very useful. Thanks very much for helping. I love the apps, numbers, pages etc. Just learning, I worked always with Microsoft excel, word etc but once you tried numbers you will never go back to Microsoft. Thanks again for this great tutorial. We don’t have a new IMac but your video’s will defenetly make the choice to buy a new one very easy. 👍👍👍👍👍👍👍👍
For years I have been calling for the restoration of such helpful functionality, it also works on iOS for the first time! P.S. I don't need to keep the old system anymore only for mail marge. Now I "calling" for shadow on tables, still can't do this without hack.
Hello Gary. Great video simplifying a feature we’ve been waiting for. While playing with the feature, I noticed that you can add custom fields. In order to achieve that, you need to have the info you want in numbers table then mail merge icon in pages -> add merge field -> add from spreadsheet. You will see the headers of your numbers table in the mail merge fields list. Thank you Gary. Appreciated.
Great video! But can you show us how to use mail merge for labels?
You can't. Mail Merge = one record of data merged with one page. But you can print labels using other techniques. See ua-cam.com/video/DrGQFu3jMaU/v-deo.html
That was just incredible! Thanks very much, Gary!
super helpful
Thank you for sharing. It helped me to mail merge it.
Great info Gary. Thanks very much. Very helpful.
Very helpful Gary, thank you!
Finally Apple restored the functions already present in Page09!
Only took 13 years!
Hi Gary, very informational. Thank you. Can you tell us how to include a weblink in the merge. I'm able to merge the data from the link field in numbers spreadsheet, but the link itself is not merging.
Have never tried that. Doesn't really apply to a typical situation (printing) So I suppose that isn't supported, maybe? Depending on how many you have, I suppose you could select each one and use Command+K to turn a URL into a link.
Glad to have found this one, but disappointed we can't then send via Apple Mail. Thanks!!!
Sending mass emails is a very different thing than printing variations using Mail Merge. To send mass emails, you need an email provider like Aweber, Constant Contact or Mail Chimp. That what those are for.
Very informative Video. Are you aware of Pages feature to print USPS compliant Barcode? ||...|..||....||, etc?
Thanks! Can Mac do a "email" mail merge using the Mac mail program? or another email program? Using email would be much more useful for me.
No. That's something that needs to be done with an email service, not a local client app on a consumer machine. Something like Aweber, MailChimp or Constant Contact.
Great video, but was looking for creating labels. I can't seem to get Keynote to put many merged addresses on only one page (such as for a sheet of labels).
Mail Merge is one record = one page. I did a video on labels: ua-cam.com/video/DrGQFu3jMaU/v-deo.html
Very useful information, thank you for sharing
Brilliant! Thank you 🙏
Excellent!
Thank you.
Wow, that only took a whole decade after Apple trashed Pages '09!
Only at Apple!!
Thx for the video. I've a question: we can't send emails by mail merge using Mac mail like in word+excel+outlook right? If we can't, what's the point lol?
No, you'd want to use an email sending service (online, not a local app) for that. Personal email not really meant for sending out mass messages.
great video, thanks Gary! Is there a way to do a merge with just one contact? Say you're sending a single birthday card and you want to print an envelope for a person in your contacts. Rather than merge an entire list and have to delete things, can you just do one?
Sure. Just include one. But if you just want envelopes, the Contacts app is the right app to use. Don't put all that work into a Pages Mail Merge when the Contacts app can do it very easily.
@@macmost Thanks for the reply. I did find a way to do a single contact merge in Pages. Turns out you just drag and drop your contact (from the contacts app) onto the merge fields (like Name, address, etc) and they auto-populate. Saves a few cut-and-paste clicks and you get just the info you want.
At least the file still opens on "Pages" Catalina. The other day I was trying the pivot tables on Big Sur numbers and had to revert to a previous version so I could open it up on Catalina numbers 11.1
Finally, thanks Gary👍
Your videos are the best. But you know that. Years ago there was a way to print a ZIP CODE on the envelope that the app applied automatically. I think MS Word Mac did that. But that no longer exists. How can I find a way to do that? Thanks.
Not sure what you mean. Like it would figure out the zip code from the street address? Maybe a special feature of Word, but I've never heard of it.
Gary, I'm on 12.2 now, and just went to use the new mail merge for the first time. But I can't seem to get the Merge or the Add Merge Field buttons enabled. I'm starting with a blank template, and I've tried including a document body and NOT including a document body. Help?
Did they remove the mail merger feature on pages??? This video was so helpful, but I can't find the merger option when clicking document :(
Still there. You have to set it up right so follow the video.
Thanks for the great video Gary - any idea if they allow you to reference an image file? To add a custom logo or image to each letter?
No, definitely nothing like that.
Hi, do you know how to mail merge if you don't have pages on your Mac (OS 10.13) ? I have word & Excel
Thanks for the video. How do I do the equivalent but send a bunch of Emails with personalised name fields at the end instead of printing letters or envelopes. I mean, say I have a Smart List of 3 people (Wendy, Steve and John) in Contacts and I want to send Emails to each of them that start with "Dear Wendy" or "Dear Steve"? Thank you.
There's no easy was to do that using the Mail app. For 3, just do it manually. But for lots more, you should use an email newsletter/marketing service to send mass emails, not a local email client app.
It's great, but it is possible to also mail-merge the Contacts Image field?
I try to make ID cards, so I do need the photo as well
No, I don't think so. You'll have to build something like that manually.
@@macmost I hope Apple will integrate this in the future. I don't want to use MS Excel and Word, where it is possible ....
Hi Gary, Is there anyway to do an email merge with Apple products or do I still need to use Microsoft?
So to send out an email messages to a list of people, but with different content in each message? Even with Microsoft, you need to worry about stepping on your email provider's rules for sending out mass email, or perhaps getting yourself blacklisted as a spammer by services that notice too many messages coming from one person. I suggest using a proper email service (Aweber, Constant Contact, MailChip, etc) for something like that.
Thank you! Is it possible that now mail merge does not work again?
Not sure what you mean.
@@macmost When I open a new sheet in Pages I can't see the Merge button anymore. I did when you uploaded the video and. try to make test with them but seems that does not work anymore.
@@esthercasado7491 Not sure why you aren't seeing it. Definitely still there, still the same.
Kind of silly they don’t allow you to add your own mail merge fields (like almost any other implementation). Hopefully they will add that capability. The lack of mail merge has forced many enterprise users to not use Pages, so this is a major improvement. 😀
hi thanks for your great content can I ask a question when you finish your mail merge with a spreadsheet from numbers can you filter the content example if you are a teacher and student are satisfactory can filter only the satisfactory student thanks
You mean so you only get pages for the ones that are shown according to the filter? I don't know. Try it with a quick experiment and see.
Thanks bunches
Thank you
Hi Gary, great video! Thank you. I ran into an issue, that when I try to merge my spreadsheet, where it says select I cannot choose name or address, it only gives me letters from A-R. Do you know what that issue is?
I had this problem too, and couldn't figure it out. I saw that the letters correspond to the columns on the spreadsheet I chose. I just went ahead and selected the letters for the columns I needed for the names and addreseses and clicked Merge and Preview. The first envelope was addressed to those letters, but all the rest had the correct addresses contained in the columns I chose. To print out the envelopes, I just omitted the first one. This is a workaround and I wish I had a better solution, but it works.
I had this problem too. Pls kindly someone have a suggestion.
Hi Gary, thanks for the useful video. Is there any way to send email with Mail Merge on Pages like MS Word Mail Merge? I would like to send greeting email with individual names from my client list.
No, Mail Merge in Pages is for creating documents. If you want to send out mass emails, use an email service (Aweber, Constant Contact, Mail Chimp, etc). Not a good idea to send out mass emails like that using personal email accounts anyway (rules, limits, etc).
@@macmost Thank you very much for your advice!!
I have a Contact list that has a Photo of the Contact on the top. Can I create a document in Pages that shows the appropriate photo as we ll as all the other merge field data? Also, I had created a group name in Contacts for select members of our motorcycle club but could not see that as an option when setting up the document in Pages.
I don't think you can access the photo. Not sure why the Group (List) isn't showing up for you there.
Hii Gary how about sending e mails with mail merge, what would be the subject of the e-mail for let say 200 e-mails.
Mass email broadcasts are different than mail merge to a document. Usually, you would use an email service for that, not an app on your Mac. Probably not a good idea to use personal email for sending that many anyway, as most services have limits and rules against it.
Nice video AND loved the shout out to Planet Facts! 🪐🔭
I'm trying mail merge with a postcard template - it has two recipients per page - I get the same recipient on both instead of 2 recipients.
Mail Merge is meant to work with one per page. You'll need to treat them like labels instead of document pages if you want to do more. See ua-cam.com/video/DrGQFu3jMaU/v-deo.html
Hi Gary, Thanks. is there a way to create a merge field that merges pathnames of jpgs. in a numbers column? Thanks.
Not sure what you mean. For inserting images? No.
Once the mail merge is done, can I save each page as individual PDFs?
They would "print" as a single PDF. You could print just one page at a time each to its own PDF. Or you could copy and paste pages from the big PDF in Preview to make single-page ones. Might be able to make a Shortcut that does it if you have some coding skills.
Really good and timely. I need to create a phone/address directory for a club I belong to (400+ members). I could see using Mail Merge, but a little nervous on importing from Numbers. Do you recommend using Mail Merge or some other means?
It is only Contacts or Numbers. Not sure what you mean by "a little nervous" -- what is your concern?
@@macmost A little nervous was probably the incorrect use of the word nervous. That said, I haven't used Mail Merge in years, so I thought this might be the solution to my project of wanting to create a phone/address directory. But, I can't figure out how to have a number names/addresses to appear on one page - if that is at all possible. My "nervousness" was whether or not all would be kept in alphabetic order and display properly when having the name appear in 2 or 3 columns per page. My best.
@@billtoney9707 Since you are in Club MacMost (Patreon), look for the video later today that may give you some ideas.
@@macmost Today's video was good and certainly a positive step toward what I want to do. Since there will be multiple columns, the issue will be being sure that in alpha order from the last of column 1 will properly move to column 2 and then to 3, etc. and back to column 1 on the next page. Guess I will have to manually set up the order in Numbers. Shouldn't be too difficult, but would prefer an automated process. Will give it shot in the AM. You are much appreciated.
Nice one Gary from a fellow Gary. I just tried this and the contacts I have are from Google and these don't work with mail merge it seems only contacts that are in icloud?
Maybe. Have you tried "On My Mac" ones? What happens if you just copy them to On My Mac to use in the Mail Merge. Though it is probably better to just use them from a spreadsheet instead.
is the mail merge feature also available on pages for icloud?
I don't think so. But look and see.
hi gary , how to use mail merge fields inside table?????
Not sure if you can. But why put the fields in a table anyway? Just use text boxes. What is it you are trying to DO, exactly, that requires tables?
Hi Sir Gary, how can i send mail merge as pdf attachment to an email? Thanks in advance.
No way to do that with this feature. Hard to suggest an alternative without knowing more about what you want to do, exactly.
Is it possible to mail merge with email addresses and send out that way?
That's a different animal. You are talking about mass emailing. Look into using a service like Aweber, MailChimp, Constant Contact, etc, for that.
GREAT walkthrough!
Such a shame it took Apple about a decade to return this functionality!
I have the correct version of pages and I clicked on documents like you said after clicking on a envelope template BUT the mail merge button isn't there. Please help.
After selecting the Documents sidebar, did you scroll down to the bottom?
@@macmost yes. I followed your instructions to the T. The mail merge button wasn’t there.
@@melissachae28 I can't thunk of any reason why that would be. Something else must be different. Call Apple Support and they should be able to walk you through it and maybe spot the problem.
Still doesn’t seem to be a full Mail merge. Doesn’t look like you can have multiple records per page (I.e. to make sheet of mailing labels).
No, it doesn't seem to have that. I would see that as a different function, not really a Mail "Merge." Contacts does mailing labels, and of course there are tons of specialty apps that do it.
Am I right that it won’t pull custom fields from Contacts?
Not sure. Try and see.
For some reason, on my M1 Mac, I only have 12.0, and it doesn't show an update in the App Store. My MacBook Air got the update, but not my 24". iMac.
Just try again. Command+R where there to update.
I had the same thing.
I went to the App Store selected Pages directly there and then it let me update it. You have to do the same thing for Numbers and Keynote, auto-update seems to be broken.
Hi, I hope you can help me, I'm trying to create Tickets in Pages with a numbering system and I'm so lost. Please help. ready to pull my hair out
Is it one ticket per page? Then you should be able to do it with this.
This is great, however, i’d like this to be evolved even further, for example, to use a spreadsheet to create multiple documents. I run a law practice and it would be helpful to have a set of template documents regarding setting up a LLC and combine them with a spreadsheet in mail merge to fill out these with data 😬
I find that’s setting up mail merge seems at times to be very tedious, but once set up, mail merges can be sent out really quickly. It’s almost like the fact that so much programming is necessary for something to be super simple. In the end, it’s worth it. Especially for your situation.Hi Gary. Another great video explaining a rather complex subject that can produce simple and effective results. You make me realize that a lot of the software I used to pay for can be done natively from within Mac. This is really valuable, both literally and figuratively. You’ve saved me a ton of money. Thank you so much!
So sorry I added my paste of my edited comments to Gary. I hope you get the idea though.
@@howardlevinger4571 yes, it will be great when I want to send greet cards etc., but it would be much more useful when it could produce various documents from the spreadsheet data 😉
@@originalmagneto I did what you want to do but with contracts and invoices (not a lawyer). It took a long time to set up but once set up, it was like magic! Also, wording changed over the years with experience but the merge fields generally stayed the same. Stay with it; you will be rewarded! By the way, Gary’s videos are the best tutorials I’ve found. Deep dives, simply stated.
@@howardlevinger4571 I’ve had some app made with AppleScript but it was complicated for me personally :/ Did you use AppleScripts too?
Yesssss!
Can I export them as individual pdf also ??
No. If you print to PDF you get one PDF just like you would get one "print job."
@@macmost so I can’t export them as individual pdf with their names unless I use the script feature ?
@@macmost also thanks Gary like a million thanks to your videos they save so much time 😊🙏🏻
@@doctorarvindram Or you could open the PDF in Preview and drag each page from the sidebar to a folder in the Finder to export them. I don't know how many pages you have so I don't know if that is a good solution.
Pls I need to work with labels. Labels is not showing in Pages. What can I do?
What, specifically, do you need to do with labels?
@@macmost I need to send it to somebody who will send a mailing newsletter out for us, he puts the labels on envelopes
He doesn't have a printer for envelopes
We have MacBook Pro with Mac IOS 14, Office 2021 for Mac
@@mtliebr6158 OK, so printing address labels for envelopes. For that see ua-cam.com/video/DrGQFu3jMaU/v-deo.html
I heard you pronounce 'envelope' as 'onvelope'. I've been wanting to know is this a southern thingy?
Not southern. I guess it could be my Philadelphia accent.
How do you send it as emails though💀 I’ve been searching for hours💀
What’s your situation? How many emails do you want to send and to whom? Like is this for work, or a school or something?
While I appreciate the addition of the feature isn't this about 5 years too late?
Most notably, it doesn't work with Apple Mail. Isn't there an inherent flaw in the feature when it doesn't work with the App whose title it literally has in it's own name?
I like Pages. And it's always nice to see it get better. But this is like announcing a new DVD format when we are all now viewing movies and TV shows online..... Aren't we somewhat more of a paperless society now with Email Blasts and E-signing documents? Raise your hand if you want to go back to Avery labels and printing envolopes. I can't remember the last time I sent a letter....
I think the problem with doing Email Merge rather than document "Mail" Merge is ISPs certainly don't want to make it easier for people to send out mass emails. We want solutions to spam, not things that would enable even more. Neither you nor I would use these for spam, of course, but how to stop others?
Also, not sure if you realize that most ISPs have daily email send limits. We rarely hit them, but something like Email Merge would mean it would happen more often, and sometimes without an error message or warning.
I think using server-based email newsletter services is the right way to go for things like this.
Very good, except you move WAY too fast. Slow down!
Sorry. This mail merge function in. 2023 is lacking essential features like email as target for the mail merge. Office 365 has this as an option where you use a csv file as source and target can be either print or email which is more modern and environmentally friendly not to say quicker. Makes this function kinda useless. I have only ever used mail merge for email campaigns
I was not aware that Office allowed you to use Mail Merge to send emails. How do they deal with the email sending limits that most email services have?
@@macmost Well that is a good question. I guess Outlook isn’t a mass mailing tool but Office 365 has a limit of I think it’s 250 recipients which is a fair amount for personal use. I usually use it for internal stuff like mass onboarding tasks internally and have never hit any limit so it might be even higher internally. When you have composed your email/letter with merge fields usually one of the fields is the email address. You specify it as the address to send to and then choose email as distribution. You get a short form with a subject line and fire away. It uses you’d installed email client. Usually Outlook to send and sent emails end up in your sent items folder. You are the sender of the email.
2024 - That is really not working !
Where are you running into trouble? Maybe try following along with what I am doing to learn the basics, then try it with your own data.
@@macmost I found a solution! YOu have to put Texboxes first, then clic on the field and drag it into the textbox :)
I don't know how you could have made this more difficult beyond using sanscrit or some other language. WAY too complex and you never seem to get to the point.