Streamline Your Workflow with a Mac Pages Invoice Template for R&D

Mac pages invoice template for R&D

hi this is Gary with macm most.com let me show you how you can print labels with your [Music] Mac Macos is brought to you thanks to a great group of more than a thousand supporters go to mmos.com patreon there you can read more about the patreon campaign join us and get exclusive content and course discounts now recently when I did a video in using the new mail merge feature in Pages several people were disappointed that you couldn't use this to print labels the idea with mail merge is your add one name or address or other type of information per page but labels of course are several on a page so to print labels it's a very different technique and it's something that you could have done all along there's no special functionality needed I should note before we begin though that if you want to just print labels from the addresses in your contacts you don't need Pages at all you can go to the contacts app select the addresses you want go to file print and then from there click show details and then you can choose style mailing labels and from here you can print as labels even choosing for many different standard label types but to do this from Pages first we want to start off with a list of names and addresses to go on the labels now this can come from a variety of sources but let's say as an example that you have them in a number spreadsheet what I'm going to do here is combine all of these things into a real address so I'm going to start a formula with equals and then here I'm going going to use each one of these things to create it so I'm going to start with the name and then I'm going to do Ampersand and then quote and then I'm going to use option return and then quote again that puts a line feed afterwards let's do Ampersand and then let's do the street and then the same thing Ampersand quote option return quote then Ampersand and then let's do the city Ampersand quote and then a comma and a space quote and then Ampersand and then the state Amper sand again just a space in the quotes and then the zip and the result of that will give us a nice looking address copy double click on the column title here and paste so the formula is pasted there and you could see nice addresses here so now I should be able to copy all of this and paste it into my pages document so let's create the pages document next so let's first assume that you don't have any kind of template to work with you just have your sheet of labels you can either measure it or maybe you could figure out from how many there are exactly what the measurements of each label are let's assume that we have a sheet that is three labels across and 11 labels vertically I'm going to go in Pages here and go to file and convert to page layout it'll get rid of the body text and allow us to do whatever we want here with text boxes let's go to view and then show rulers and View and show layout so now we could see everything here we could go to format and under page turn off show header and footer so we have none of that now we can use the rulers to create guides since we know there are three across and maybe goes edge to edge there are no margins on these labels I can drag from the left side here and place this line where it should go which is about 83 right there and 5.66 that divides the page up into three even portions just using math there to divide 8 and 1/2 by three and now we know vertically since there are 11 of them and they're 11 in that they're 1-in labels so we can add these lines here at 1in intervals all the way down the page so there we go we have our labels let's create a text box and take this text box and place it here in the first label now depending on your printer you may have margins you have to pay attention to like a good laser printer may have nothing or maybe just a quarter of an inch here but that's okay you don't want the actual addresses to go up to the edge of the label anyway so we'll take this we'll put this in the center here and let's type in a sample address like that and get it to look like what we want maybe we want it to be left Justified like that maybe we want to change the text here and make it a different style let's make it a little bit bigger make it bold so it stands out there let's make sure it's big enough to contain those three lines and really not much more now that we have that we want to duplicate this text box in the other boxes I'm going to use the option key and click and drag with the option and it will drag out a copy of that and see how the guides there let me line it up pretty easily I'll do it again and you can spend all the time you want trying to get it perfect now we can shift click to select all three of these and option drag down and do the same thing here option drag again maybe after you have a few of them you could click and drag around all of them option click and you can see how quick and easy it is to duplicate these great so the problem is now each one of these is an individual text box we would have to copy each address and then paste it in and do it for all of them but we can link these text boxes and do it more easily so the link a text box see this round dot up here when it's selected click that and that will create the beginning of a linked list of text boxes green is the color that indicates the set and this is number one let's select this one down here I'll click and it changes to Red another set but if we click again we can switch to green and now it's going to merge the threads so now we go here click green and you see it's not going to warn us after that first time so it's a lot quicker and now we can go through and merge them all so now we have 18 linked text boxes if I select something in here and do command a for select all notice it selects everything there I can delete and I can actually type one 2 3 4 5 6 7 8 N9 you can see how it goes box to box like that so now I can go back here select all of these cells copy and then go to pages and command V to paste and look what it does it pastes them all in now it's using the style from numbers let me undo and instead go to edit paste and match style and now we use the style that we had for our Pages document if I were to go in here and select all you can see all the text is selected so I can adjust the size there like that now one of the nice things about doing this in numbers here with formulas that use we did option return instead of return that creates a line break that more closely links together the group so the returns between each one of these and the return from here to here are different that's why when we shrink it down it attempts to keep the address together now we've shrunk it down enough so two addresses can fit on one label that's why that happened but in general even though there's room for another line it's not going to you could even see here the blue indicators here you're showing it's a special type of return there as opposed to a paragraph break there now we can adjust these we can even change things like Center them all like that note that if things are a little off center now there's a lot we can do for instance let me click outside of any of these boxes so I'm not selecting text anymore do command a and I've selected all the text boxes rather than the text inside them now if I use the down arrow or drag I can move all of them at once so maybe I could reenter these like that if I need to make them l larger then dragging one box isn't going to do it but I can go to format a range and notice how the height is 77 if I increase that or decrease that or change it using a manual number it does it for all of those the same thing for the width as well so you could change the width to make it a little bit wider and they all change select them all again here and then use the left Arrow right arrow to move back and forth all together so there's a lot you can do and if things don't line up right you can always add an extra return or you can edit something just to make it just right now a lot of times you do have a template that you can work from you don't have to start from scratch for instance go to one of the largest makers of label sheets and you can go to the templates page here you can enter in the number that comes on the box there and notice that one of the templates that's usually included is pages so I click there and download the template in this case I get a template looks like this I'll open it up and you can see how it look a lot like well what we created except that things aren't linked together so if I were to go into numbers now and copy this column here go back into here and paste you can see it only pastes in that very first text box here so I'm going to have to set things up so that I can link the boxes to each other so I'll set this one up as green and I'll add for each one of these so you can see I've linked them all let's select all the text again and delete and then I'll paste them back in and you can see how all the addresses I have fill in here really nicely let's say I had twice as many addresses I could paste them in there and you can see how this indicates there's more than what fit on this page so instead of creating a second page a handy thing to do is just print this first page and then select starting here and I'm going to shift click to select here and then delete and you deleted all of those and these fill in here I've got one more than I need I'm going to forward arrow to the next one and then hit delete there so now I can print the second sheet to finish my printing notice also now you can change the style to what you want so you can change you know the font to something else you could change the style make it a little bit bigger you know Center it you know do whatever you want here and do everything else we talked about like if I do command a to select all I could go to format arrange change the height a little bit change the width like that I can reselect them all again and maybe use the left Arrow key a bunch of times there maybe recenter it down arrow so you can adjust everything in here to get it to look like what you want and then go ahead and print using this pre-made template that you've modified to make it easier to actually have these addresses put in here and notice here if I select all and copy and then go to another document let's say a Pages document and I paste them all in you can see what I get here it's basically three lines per address in this case doesn't have to be three and you can generate this any way that you want it doesn't have to come from numbers you can just type this out if you like matter of fact you can have a line break between each one just to make it easier to see and just make sure that you include that extra line in here you know if I paste this you can see it's a bit of a mess but if I select all of these text boxes go and make all these text boxes tall enough you can see it includes that extra line in there now it doesn't matter if it overflows a little bit to the next label because there's nothing there to print so now it works out nicely even though I'm starting with the document that has an extra break in there so hope you found this useful thanks for [Music] watching if you like this video click the Thumbs Up Button below to let me know I publish new tutorials each weekday hit the Subscribe button so you don't miss out