Name badges google doc merge6/11/2023 ![]() For speed format the first label and copy to the rest by clicking the Update Labels button in the Mailings tab.Ī friend sent me an Excel spreadsheet to make some labels and it misbehaved, giving me error messages when I tried to run the mail merge (it wanted me to download lots of unnecessary fonts). You may work out a better system for your needs.Īt point 1c you can stop if you only wanted to make a few labels manually, as you now have the basic template and can add in text and adjust layout, overwriting each «Next Record». While you can re-use this label ‘template’ with a different file (restart process from (2)) it doesn’t always work well and to be honest I’d start fresh, but I only do this once or twice a year. If you need to make changes affecting all labels just close the finished labels without saving and amend the underlying label design before repeating the Finish & Merge step.Ħ. Then click on “Finish & Merge” and choose Edit Individual Documents… A new Word document will open with the finished labels which you can check and amend individually if necessary.ĥ. Once happy click back into the Mailings tab, click Update Labels to copy your layout across all labels. Using the Home tab adjust the layout and appearance of the first record (top left, the only one that doesn’t say «Next Record» with colour, font, size, positioning etc. You can decide on the order and layout a bit at this stage but you’ve more control in the next stage so add them in and press OK.Ĥ. The ‘Edit Labels’ pop-up invites you to Insert Merge Field – click on that and add the fields (column headings) you want included, eg First Name will look like «First_Name». ![]() You can also select a cell range within that.ģ. If invited to “Open Document in Workbook:” click on menu to select which workbook (tab) of the spreadsheet you want to use. Select Recipients » Use an Existing List… (navigate to your data file, usually Excel (see section on troubleshooting) or notepad / plain text). Word will now automatically populate a single page with largely invisible labels (‘Select All’ / Ctrl+A to see them) all but the first containing the phrase “Next Record”.Ģ. (I used “Avery A4 and A5 sizes”, L7163 (which has 14 labels to a page, 99mm in length, 38mm in height.)ġc. You can also create your own label page from scratch with the New label option. Click on the ‘Label products’ drop-down menu and select brand, then size, then OK. Open Word: Mailings tab » Start Mail Merge » Labels (select option / OK)ġb. Big fan of the text-based version though.ġa. ![]() Note that with Excel files with multiple tabs you can select which tab is used as the data source. Data file – Excel, notepad / text document, anything that has tabulated (columnar) data.Word – open a new document, this is where you’ll make the labels.This time, I made notes!Ī mail merge involves importing a table of data (a spreadsheet in Excel form (“.xls(x)”), or as a tab- or comma-separated version in notepad) into a blank Word template so that the contents of each row in the spreadsheet is presented in label form. This is not a general ‘how to use Mail Merge’ post, it’s mostly a reminder for me for when I come to repeat this task next year and wish that this year’s me had written it down. It would be quicker for me to take a course in calligraphy and hand-write 150 name badge labels than use mail merge in Word.
0 Comments
Leave a Reply. |