That is an excellent and clear explanation for how to use Numbers and Pages to achieve just the result you want (for many different “merge” type functions). Now if anyone asks me how to print labels, I can just point them here, Thank You 😊 However, it does need to be said that Pages mailmerge implementation should include this functionality. Perhaps we will see it in the next release, Apple seems to, bit by bit, be getting the new Pages up to parity with other general purpose word processing applications.
THANK YOU! This is EXACTLY what I was looking for and your video was edited very well and explanation was clear! So many steps.... but it does the job!
Gary - thank you for (another) excellent informative video. I did have one hiccup when I pasted the formula into the column. Instead of the expected results I just got the same result in all rows. I don't know if it was because I used an existing old numbers file but I finally copy/pasted everything into a new numbers file and then the copy/paste results went as expected. Thanks again
Thank you, Gary! This was a great video and just what I was looking for. I did have one set back, but managed to find the solution. I used the Avery template for my Pages document which was time saving. I built the spreadsheet as directed, then when I copied the 'combo' column with Cmd C and went to Pages and placed the cursor in the first text box. When I used Cmd V to paste, it inserted a table with one column and with an error in each row saying "This formula can’t reference its own cell, or depend on another formula that references this cell." I then tried "Edit - Paste Formula Results." It again over layed the text boxes with a table with one column but it did have the addresses populated in the rows. It ignored the formatting of the text boxes. I refused to surrender, though. I then used "Edit - Copy Snapshot" in Numbers and "Edit-Paste" in Pages and was so happy to see it work!!!!
Yet another great video! One little extra thing that might be a useful add-on process is formatting the final printed address so that it meets the USPS preferred address format, which recommends all upper case and no punctuation, among other things, since it helps increase the accuracy of their OCR systems. Given the built-in text transformations in macOS I suspect this would be a pretty easy update to the process you describe in your video, but I thought I'd mention it anyway, since I like to make the Post Office's job as easy and efficient as possible.
All you would need to do is change the formula in the last column by removing the punctuation and surrounding it with the UPPER function. That function can easily be changed to do all sorts of things, like adding a second address line for Apartment or Suite (You would need to use the IF function)
Oh man... I had 300 lists. I was able to do this by following the instructions. It took me more than an hour. However, when I tried it again using Microsoft Word, I finished it in just 5 minutes.
Super useful video, Gary! Great timing, too, because I just took on the secretary duties for an organization I belong to, and I was just about to try figuring out how to do this! Thanks a million!
this is a bit convaluted... the person doing the instructing is top notch... well well explained... but pages is trash for mail merging for labels... which this isnt actually merging... you are formatting the doc to allow you to copy paste the info rather then dynamically merging the spreadsheet data...seems like if you have 300 lables this way sucks... cant believe i wasted time on this.
Wow thank you so much Gary another really useful video. I use a separate label making printer for printing my Christmas card labels because I didn’t appreciate I could use my Mac…..👍🏼
Numbers needs to be able to Create Labels automatically using the Print function! I can't believe that this is so complicated! This is not Apple like!!!
Gary, I can not thank you enough for this video! I just wish the powers that be (Apple, of course) would make the labels simpley print left to right, line by line. Instead, it appears they go several rows in one column then the next. I don't get it.
GREAT instructions but... I have a long list of addresses (1000s) that I need to make labels for. Is there a way to create a multi page doc, or a doc that will expand as necessary to receive all? The thought of printing 30 labels at a time then select all, paste, etc etc is not appealing! Thx
Thank you, I saw this. I only have the addresses available as VCards. Bc the export function of Outlook 2021 for Mac doesn't work properly. It only exports OLM and out of 2000 contacts it only exports 38 contacts. So I cannot produce a proper CSV or PST file even though I have the software for it.
this is very helpful , i have everything but do i HAVE to create the formula for my spreadsheet or is there a quick way if i already have the avery template i can import and itll auto populate my csv file into the box mailing label format?
There's no function in Pages that can tell what is what in an address or anything like that. If you like, you can just create the data yourself by typing or copy and paste into cells in Numbers if doing it manually is easier for you than using formulas.
Great video and very helpful. When I went to paste addresses from numbers into pages, even though I copied all, it only put in the first 33, since that's what fits on the first page. Do I have to figure out ahead of time total number of addresses and then create in pages the text boxes, etc. to every single page I need to create, or is there a way to duplicate the work done on the first page? I'm playing around with it without good results. Thanks.
You can do it 33 at a time. Or, you can create multiple pages with 33 labels on each, and then link all of those boxes since you can link text boxes from one page to the next.
@@macmost Thanks, I ended up linking the text boxes from one page to the next, but for some reason, some of the text boxes would not copy and paste properly or let me add data to them, so some of them ended up "blank". I am sure it's just operator error, but that's okay. For the most part, I had success. ;)
Hi Gary I found this video very useful THANK YOU but I have another similar favour to ask you if you choose to except it and show how to do it. I downloaded a template for making simple slim CD cover maker in PAGES but the windows are placed vertically, is there a way to place them Horizontally side by side, so that when I print it I can simply cut and fold the artwork cover, because the other way around I have to cut each window separately tape them together and insert it in jewel case. I'm pretty sure you can create a custom size templates two windows collided side by side (12X12) cm for making slim jewel case cover, I would appreciate if you can demonstrate THANK YOU AGAIN GARY. 🙏👍👍👍👍👍
Just create your own template to the exact size of the CD cover sheets. Measure the sheets and the shapes in them and recreate it in a blank Pages document.
I am new to MAC and am using your videos to try to learn tips and tricks. I followed your tutorial, made a numbers document with my addresses but when I copy the fields from my numbers document, nothing will paste into the text boxes of pages. Do you have any idea what I might be doing wrong?
Do you see the blinking cursor in the text box and can you type there before you paste? After pasting, is there enough room and is the font sized right to be able to see it? Keep playing around with it.
OMG this is horrible. New to Apple Eco System. I hope this is not the only way to do this. This is so archaic compared to Windows and Office Suite. This is such a bad process. Apple, you need to fix this to be more relevant.
@@macmost honestly, after fighting with this for two hours I just opened up my Windows laptop and did it in about 10 minutes. Maybe if I had Microsoft office installed on my Mac? Process was a lot simpler in office and built-in without having to download anything. I like the Mac, don’t get me wrong, but it’s just not as efficient foroffice work. You just have to wait forever on a windows machine for it to come to life which is why I switched. Both have their strengths and both have their weaknesses.
@@Wyttyd Yes, if what you are trying to do is a function of app MS Office, then get MS Office on your Mac and you should be able to do it the same way.
Hey Gary. Thanks for the informative video. How can we use this technique with a label printer like Rollo? I guess Rollo or other label printers consider one label as one page. Thanks in advance.
thx so much for this step by step tutorial which was easy to follow. I do however have a problem when copying from my mail list to pages. Ive tried this step several times but it just won't paste, not sure what im doing wrong and can't seem to find any information on the web to help me solve this problem. Can you help please, im trying to mail my daughters wedding g invitations so is time =sensitive thx.
Not sure what you could be doing wrong. Try pasting into TextEdit to make sure you've copied properly. If that works, then make sure you have placed the blinking text cursor in the text boxes in Pages before pasting.
All was well until I tried to copy from Numbers version 13.0 into Pages version 14.0. It won't paste. I can paste into a Notes app, but then I lose all the formatting.
Hey Gary, I just watched your Sleep vs Shutdown for housekeeping Mac video. I use Mac mini M1. Is that applicable to mac mini as well? I am concerned that the Mac mini is AC powered but the MacBooks are battery powered. In case of powercut while my Mac mini is sleeping, what could happen? I am sure I will loose unsaved data.. will it cause any hardware damage?
You should put it to sleep and almost never shut down. If power outages are a concern in your area, get a UPS: th-cam.com/video/MJY1s4przBM/w-d-xo.html
Hi. How does one add an “image” on the top of each label in pages. I need to add a brand name and logo on top of each label. Any help would be appreciated thanks!
Is it an image graphic that you have? Just drag and drop it into Pages, then copy and paste copies of that and place them at the top of each label on the page.
Hi Gary. Thanks for this video. You showed at the beginning how to do it with Contacts. But this label doesn't show country. I completed all address fields. I found that it shows/prints country only when you put country in the same box as city. Any idea why?
@@josefhab8095 There's an option in the print dialogue you have to tick to include country or region. It's under mailing labels > label. It also lets you exclude your own country.
@macmostvideo I am fairly new to mac. I have a picture of a photo album page that has five pictures on it. What method or application to separate those five pictures into single pictures each? I currently use mac screenshot app and the crop feature to single out one of the five pictures. This is time consuming to do it that way. Is there a better way to do this? Thank You
You can use any image editing app or Preview. Open the image in Preview (should be the default app) and select one photo, then File, New From Clipboard. Then save. Do for all 5 pictures. If this is something you need to do many times for many photo album pages, and these are scanned pages, consider using Image Capture to scan, use the Overview and select the 5 pictures separately and scan.
I'm trying to figure out (similar to labels) how to make a pages template to pull info from a spreadsheet, but the sheet is 8 pocket certificates/page and the data from the spreadsheet is First Name, Last Name, Date, & Achievement. Unlike an address the info is not in consecutive lines, but text boxes on each certificate. The actual paper is a preprinted perforated form. Any suggestions?
@@macmost So I can get the copy/paste to work like the labels. I guess I was wanting to figure out if you can do a mail merge instead. Is there a way to make these merge fields and on the same page go to the 'next' field instead of a new page?
Everything goes good until I try click the circle to link them into a string. It moves my lines up and down into the boxes above or below it. Tried it 3 times now and every time it does it.
I have my spreadsheet, I set up the pages document, linked all the label boxes and it still puts one label per page. The labels act as if they are not linked but it shows 1-30, all in green on the page.
@@JanetWinters-k4p So it sounds like something is going on with the text you are pasting in then. If the text flows from box to box, then the address you paste in should do as well. They are just text like you are typing. Not sure what is going wrong with it when you paste. Try typing the first two or three labels and see if that works. Maybe look at the text you are pasting in TextEdit first before pasting into Pages to see what it looks like.
@@macmost Yes, if I type names and addresses in, it flows to the next label. I used your formula to make a column with address, including street, city, state and zip. Can you tell anything by seeing the formula I typed in? [Mail Add. Individuals&" "&City Individuals&", "&ST Individuals&" "&Zip Individuals] Of course the brackets are not there on the spreadsheet. There is a little blue arrow pointing back after the Individuals name. No blue arrow or paragraph symbol (?) after the zip code. I so appreciate your time in helpping me with this. I print a newsletter for our historical society and used to use Office apps but I'm liking all the Apple apps better now. But this has been a struggle.
@@JanetWinters-k4p Did you try pasting the text you copies from Numbers into TextEdit to see if it was all there? Maybe you are only copying the first address, not all of them?
@@cookiemiles8016 If you do this all the time, you can easily use Numbers to create the text just like Gary did earlier. You could even use the exact same spread sheet, but instead of using a different address for the next line, create a formula that copies the line above, then customize it for exactly what you want as many times as you want.
@@macmost I probably shouldn't complain about a free product. I still do the majority of my work off my macbook pro and only need to print a client list of 300+ labels once a year.
All the same? That's easier. Just get the Avery template, fill in the text box (or add one and fill it in if the template doesn't provide a text box) with the address. Then copy and paste to the other labels on the sheet.
Thanks for answering. I heard that, but in my brain, I thought you wanted me to type it in a particular place, like a box. I just wasn't getting that that would bring up the box.@@macmost
I tried this and I’m failing, please help! For the addresses I need the formula to be for: Title First Last address City state zip Closest I’ve gotten it looked like: TheSmithFamily111Mainstreet NewYorkNewYork22222
That is an excellent and clear explanation for how to use Numbers and Pages to achieve just the result you want (for many different “merge” type functions). Now if anyone asks me how to print labels, I can just point them here, Thank You 😊 However, it does need to be said that Pages mailmerge implementation should include this functionality. Perhaps we will see it in the next release, Apple seems to, bit by bit, be getting the new Pages up to parity with other general purpose word processing applications.
Thank you! In the old days I might have been able to figure this out -- your system worked and it was far better than the "printed" documentation.
Thank you Gary! it worked for my real estate mailing labels.
THANK YOU! This is EXACTLY what I was looking for and your video was edited very well and explanation was clear! So many steps.... but it does the job!
Wow I can’t stop learning from this channel. Thankyou
Gary - thank you for (another) excellent informative video. I did have one hiccup when I pasted the formula into the column. Instead of the expected results I just got the same result in all rows. I don't know if it was because I used an existing old numbers file but I finally copy/pasted everything into a new numbers file and then the copy/paste results went as expected. Thanks again
Just what I was looking for, thank you. I'm learning all the time via your videos they are very informative.
Thank you, Gary! This was a great video and just what I was looking for. I did have one set back, but managed to find the solution. I used the Avery template for my Pages document which was time saving. I built the spreadsheet as directed, then when I copied the 'combo' column with Cmd C and went to Pages and placed the cursor in the first text box. When I used Cmd V to paste, it inserted a table with one column and with an error in each row saying "This formula can’t reference its own cell, or depend on another formula that references this cell." I then tried "Edit - Paste Formula Results." It again over layed the text boxes with a table with one column but it did have the addresses populated in the rows. It ignored the formatting of the text boxes. I refused to surrender, though. I then used "Edit - Copy Snapshot" in Numbers and "Edit-Paste" in Pages and was so happy to see it work!!!!
Yet another great video! One little extra thing that might be a useful add-on process is formatting the final printed address so that it meets the USPS preferred address format, which recommends all upper case and no punctuation, among other things, since it helps increase the accuracy of their OCR systems. Given the built-in text transformations in macOS I suspect this would be a pretty easy update to the process you describe in your video, but I thought I'd mention it anyway, since I like to make the Post Office's job as easy and efficient as possible.
Does it help USPS to print bar codes on labels as well?
All you would need to do is change the formula in the last column by removing the punctuation and surrounding it with the UPPER function. That function can easily be changed to do all sorts of things, like adding a second address line for Apartment or Suite (You would need to use the IF function)
Oh man... I had 300 lists. I was able to do this by following the instructions. It took me more than an hour. However, when I tried it again using Microsoft Word, I finished it in just 5 minutes.
Super useful video, Gary! Great timing, too, because I just took on the secretary duties for an organization I belong to, and I was just about to try figuring out how to do this! Thanks a million!
Thank you so much for this helpful video. I was able to do my work super fast.
Thank you! This is a great video.
this is a bit convaluted... the person doing the instructing is top notch... well well explained... but pages is trash for mail merging for labels... which this isnt actually merging... you are formatting the doc to allow you to copy paste the info rather then dynamically merging the spreadsheet data...seems like if you have 300 lables this way sucks... cant believe i wasted time on this.
Great tutorial and perfect for my project. Thank you.
Wow thank you so much Gary another really useful video. I use a separate label making printer for printing my Christmas card labels because I didn’t appreciate I could use my Mac…..👍🏼
Thanks this really helped me with my 50th reunion mailer
Great job,Gary! So clean and clear.
Thank you very much for this video. Professional, clearly explained. Even I could follow it. :) Thank you.
A very useful and informative video tutorial today! I never knew you can do this. Always learning something new! Thank you, Gary! 👏🏻❤️
Good information! 👍
Awesome tutorial! Thank you!
Thanks! Very Helpful!
thank you so much for this super informative and beneficial video.
Numbers needs to be able to Create Labels automatically using the Print function! I can't believe that this is so complicated! This is not Apple like!!!
Why Numbers? You can do it in Pages and Contacts, and lots of third-party apps.
Agree. Excel has had this forever.
Gary, I can not thank you enough for this video! I just wish the powers that be (Apple, of course) would make the labels simpley print left to right, line by line. Instead, it appears they go several rows in one column then the next. I don't get it.
Thank you so much! Life saver! God bless!
You are my hero😊thank you !
Excellent. Thank you
Keep up the good work.
Great info. And I saw an address from Manlius, NY. I know that small town!
Nice. Those addresses were randomly generated though... cool coincidence.
Very helpful
GREAT instructions but... I have a long list of addresses (1000s) that I need to make labels for. Is there a way to create a multi page doc, or a doc that will expand as necessary to receive all? The thought of printing 30 labels at a time then select all, paste, etc etc is not appealing! Thx
A multi-page doc, sure. It will take some time to link all of the boxes though. So maybe consider a third-party label app instead?
MacMost Excellent!!!
Thank you, I saw this. I only have the addresses available as VCards. Bc the export function of Outlook 2021 for Mac doesn't work properly. It only exports OLM and out of 2000 contacts it only exports 38 contacts. So I cannot produce a proper CSV or PST file even though I have the software for it.
Thanks bunches
Epic! Thanks
Thanks for the video. Is it possible to do same on iPad as I’m struggling with the return function on the keyboard for iPad
Should be possible to do the same, sure. But it will take some work.
Nice explanation and demonstration. It's too bad Apple doesn't pay more attention to usability, especially given their history
this is very helpful , i have everything but do i HAVE to create the formula for my spreadsheet or is there a quick way if i already have the avery template i can import and itll auto populate my csv file into the box mailing label format?
There's no function in Pages that can tell what is what in an address or anything like that. If you like, you can just create the data yourself by typing or copy and paste into cells in Numbers if doing it manually is easier for you than using formulas.
Great video! Printing holiday labels, is there a way to add a graphic that fits that holiday to all the labels?
Sure. Just add a shape or external image and copy and paste on to all of the labels.
Great video and very helpful. When I went to paste addresses from numbers into pages, even though I copied all, it only put in the first 33, since that's what fits on the first page. Do I have to figure out ahead of time total number of addresses and then create in pages the text boxes, etc. to every single page I need to create, or is there a way to duplicate the work done on the first page? I'm playing around with it without good results. Thanks.
You can do it 33 at a time. Or, you can create multiple pages with 33 labels on each, and then link all of those boxes since you can link text boxes from one page to the next.
@@macmost Thanks, I ended up linking the text boxes from one page to the next, but for some reason, some of the text boxes would not copy and paste properly or let me add data to them, so some of them ended up "blank". I am sure it's just operator error, but that's okay. For the most part, I had success. ;)
thanks
Can I make the font smaller on labels or better yet add a line to the address? I need this for people that live in nursing homes, etc
Make the font size anything you want. Just adjust it as you would any text in Pages.
Hi Gary I found this video very useful THANK YOU but I have another similar favour to ask you if you choose to except it and show how to do it. I downloaded a template for making simple slim CD cover maker in PAGES but the windows are placed vertically, is there a way to place them Horizontally side by side, so that when I print it I can simply cut and fold the artwork cover, because the other way around I have to cut each window separately tape them together and insert it in jewel case. I'm pretty sure you can create a custom size templates two windows collided side by side (12X12) cm for making slim jewel case cover, I would appreciate if you can demonstrate THANK YOU AGAIN GARY. 🙏👍👍👍👍👍
Just create your own template to the exact size of the CD cover sheets. Measure the sheets and the shapes in them and recreate it in a blank Pages document.
I am new to MAC and am using your videos to try to learn tips and tricks. I followed your tutorial, made a numbers document with my addresses but when I copy the fields from my numbers document, nothing will paste into the text boxes of pages. Do you have any idea what I might be doing wrong?
Do you see the blinking cursor in the text box and can you type there before you paste? After pasting, is there enough room and is the font sized right to be able to see it? Keep playing around with it.
Just about everything I know about a Mac, I've learned from Gary's videos.
OMG this is horrible. New to Apple Eco System. I hope this is not the only way to do this. This is so archaic compared to Windows and Office Suite. This is such a bad process. Apple, you need to fix this to be more relevant.
If you want something simpler you can get one of many apps that are available that print labels. This tutorial is about how to do it in Pages.
@@macmost honestly, after fighting with this for two hours I just opened up my Windows laptop and did it in about 10 minutes. Maybe if I had Microsoft office installed on my Mac? Process was a lot simpler in office and built-in without having to download anything. I like the Mac, don’t get me wrong, but it’s just not as efficient foroffice work. You just have to wait forever on a windows machine for it to come to life which is why I switched. Both have their strengths and both have their weaknesses.
@@Wyttyd Yes, if what you are trying to do is a function of app MS Office, then get MS Office on your Mac and you should be able to do it the same way.
Hey Gary. Thanks for the informative video. How can we use this technique with a label printer like Rollo? I guess Rollo or other label printers consider one label as one page. Thanks in advance.
You would probably have to use their custom software.
@@macmost thanks for your suggestion Gary
thx so much for this step by step tutorial which was easy to follow. I do however have a problem when copying from my mail list to pages. Ive tried this step several times but it just won't paste, not sure what im doing wrong and can't seem to find any information on the web to help me solve this problem. Can you help please, im trying to mail my daughters wedding g invitations so is time =sensitive thx.
Not sure what you could be doing wrong. Try pasting into TextEdit to make sure you've copied properly. If that works, then make sure you have placed the blinking text cursor in the text boxes in Pages before pasting.
@@macmost thx so much for your quick response I’ll give it a go!❤️
Are you kidding me!!! There has got to be a simpler way!
All was well until I tried to copy from Numbers version 13.0 into Pages version 14.0. It won't paste. I can paste into a Notes app, but then I lose all the formatting.
Check for updates. Numbers 14.0 came out the same day as Pages 14.0.
Hey Gary, I just watched your Sleep vs Shutdown for housekeeping Mac video. I use Mac mini M1. Is that applicable to mac mini as well? I am concerned that the Mac mini is AC powered but the MacBooks are battery powered. In case of powercut while my Mac mini is sleeping, what could happen? I am sure I will loose unsaved data.. will it cause any hardware damage?
You should put it to sleep and almost never shut down. If power outages are a concern in your area, get a UPS: th-cam.com/video/MJY1s4przBM/w-d-xo.html
Following your instructions to a T, and no matter what I do, it just gives me an error that says "this formula contains a syntax error." Help!
All I can suggest is to check the formula carefully. Even one character that isn't right will cause an error.
Hi. How does one add an “image” on the top of each label in pages. I need to add a brand name and logo on top of each label. Any help would be appreciated thanks!
Is it an image graphic that you have? Just drag and drop it into Pages, then copy and paste copies of that and place them at the top of each label on the page.
My numbers column won't paste to pages, am I doing something wrong? Everything has worked up to that point. I downloaded a template from Avery .
What happens when you try? Maybe it does paste, but the text boxes are too small to display the text.
Hi Gary. Thanks for this video. You showed at the beginning how to do it with Contacts. But this label doesn't show country. I completed all address fields. I found that it shows/prints country only when you put country in the same box as city. Any idea why?
Sorry, I don't know. Play around and try things.
@@macmost it works/prints only if you put country behind the city and again in country box. However then it prints country twice. Bug?
@@josefhab8095 There's an option in the print dialogue you have to tick to include country or region. It's under mailing labels > label. It also lets you exclude your own country.
@macmostvideo I am fairly new to mac. I have a picture of a photo album page that has five pictures on it. What method or application to separate those five pictures into single pictures each? I currently use mac screenshot app and the crop feature to single out one of the five pictures. This is time consuming to do it that way. Is there a better way to do this? Thank You
You can use any image editing app or Preview. Open the image in Preview (should be the default app) and select one photo, then File, New From Clipboard. Then save. Do for all 5 pictures. If this is something you need to do many times for many photo album pages, and these are scanned pages, consider using Image Capture to scan, use the Overview and select the 5 pictures separately and scan.
I'm trying to figure out (similar to labels) how to make a pages template to pull info from a spreadsheet, but the sheet is 8 pocket certificates/page and the data from the spreadsheet is First Name, Last Name, Date, & Achievement. Unlike an address the info is not in consecutive lines, but text boxes on each certificate. The actual paper is a preprinted perforated form. Any suggestions?
Probably the easiest way is to just copy and paste the data into a format you can use.
@@macmost So I can get the copy/paste to work like the labels. I guess I was wanting to figure out if you can do a mail merge instead. Is there a way to make these merge fields and on the same page go to the 'next' field instead of a new page?
Everything goes good until I try click the circle to link them into a string. It moves my lines up and down into the boxes above or below it. Tried it 3 times now and every time it does it.
Not sure what you mean. Watch carefully how I do it and practice on a sample document to get the hang of it.
I have my spreadsheet, I set up the pages document, linked all the label boxes and it still puts one label per page. The labels act as if they are not linked but it shows 1-30, all in green on the page.
Experiment and test. For instance, if you just clear out all of the text and type some lines, does it flow from box 1 to box 2?
@@macmost Yes, if flows from box to box. Is there a setting I'm missing or something?
@@JanetWinters-k4p So it sounds like something is going on with the text you are pasting in then. If the text flows from box to box, then the address you paste in should do as well. They are just text like you are typing. Not sure what is going wrong with it when you paste. Try typing the first two or three labels and see if that works. Maybe look at the text you are pasting in TextEdit first before pasting into Pages to see what it looks like.
@@macmost Yes, if I type names and addresses in, it flows to the next label. I used your formula to make a column with address, including street, city, state and zip. Can you tell anything by seeing the formula I typed in? [Mail Add. Individuals&" "&City Individuals&", "&ST Individuals&" "&Zip Individuals] Of course the brackets are not there on the spreadsheet. There is a little blue arrow pointing back after the Individuals name. No blue arrow or paragraph symbol (?) after the zip code. I so appreciate your time in helpping me with this. I print a newsletter for our historical society and used to use Office apps but I'm liking all the Apple apps better now. But this has been a struggle.
@@JanetWinters-k4p Did you try pasting the text you copies from Numbers into TextEdit to see if it was all there? Maybe you are only copying the first address, not all of them?
Could you do this with Mail Merge like in MS Word?
Mail Merge is something else. See th-cam.com/video/6CB0sIfxEg0/w-d-xo.html
If using a template in pages, how do you get it to print an entire page of one individual label?
Just put the same information in each label. Copy, paste, paste, paste...
@@macmost So there is no way to do it all at once? I have been doing it individually, but thought there was an easier way.
@@cookiemiles8016 Once you put them on every label, you print it once. The paste, paste, paste only takes a minute.
@@cookiemiles8016 If you do this all the time, you can easily use Numbers to create the text just like Gary did earlier. You could even use the exact same spread sheet, but instead of using a different address for the next line, create a formula that copies the line above, then customize it for exactly what you want as many times as you want.
Thank you for this explanation but holy crap on a cracker, it shouldn't be this difficult. Apple needs to sort this out.
If you want easy, I think there are some apps that make it easy to do. Look in the App Store and see.
@@macmost I probably shouldn't complain about a free product. I still do the majority of my work off my macbook pro and only need to print a client list of 300+ labels once a year.
How can I rotate the text ?
Select the text box, then in Format, Arrange you can set the rotation. You can also Command+drag the dots around the text box to rotate.
thank you so much btw will it also work for rotating image/logo ??@@macmost
@@nuzzky Yes. Try it and see.
When i print i dont see the guides lines.... helppp pls
What guide lines do you mean, exactly?
I mean the lines. Sorry im italian
@@macmost horizontal and vertical guidelines
@@MaTo-v9s To add guidelines turn on the Rulers first, then drag down or across from the ruler.
are you kidding me? how do I just print a sheet of Avery mailing address labels with all the same address?
All the same? That's easier. Just get the Avery template, fill in the text box (or add one and fill it in if the template doesn't provide a text box) with the address. Then copy and paste to the other labels on the sheet.
You lost me at "start a formula." I watched it over and over, and I don't know how you got that box to pop up to insert the formula.
Just type =. (I say that in the video too)
Thanks for answering. I heard that, but in my brain, I thought you wanted me to type it in a particular place, like a box. I just wasn't getting that that would bring up the box.@@macmost
👏🏼👏🏼👏🏼👏🏼👏🏼 🌟🌟🌟🌟🌟
Wow. That’s an ugly process
you literally saved my day
kind appreciate your effort 😎😎😎
Can one import a template from Avery and eliminate this page setup step?
You can certainly try it. In my experience it will still need some work.
I tried this and I’m failing, please help! For the addresses I need the formula to be for:
Title First Last
address
City state zip
Closest I’ve gotten it looked like:
TheSmithFamily111Mainstreet
NewYorkNewYork22222
Look at the section "Preparing Your List" and I show you how to add spaces and the like.
I see avery in the UK (avery.Co.uk) only gives sizes now not the product number it used to. Also only has templates for MS Word