![how to mail merge labels from excel to word 2013 video how to mail merge labels from excel to word 2013 video](https://media.gcflearnfree.org/ctassets/topics/233/mail_step4_address2.png)
- #How to mail merge labels from excel to word 2013 video how to
- #How to mail merge labels from excel to word 2013 video download
- #How to mail merge labels from excel to word 2013 video windows
#4: Prepare Your DataĪlthough Word does a good job of displaying the data where you want it (provided you’ve matched up the fields in the right way), it doesn’t include tools for doing things like grouping your data into subsets. So what kind of end product do you want to send? Know before you begin creating your project what the outcome will be, and that will help guide you in your formatting and the types of information you include in the merge. You can create labels, letters, envelopes, email messages, and a directory, which lists your data records one after another. Word gives you the option of creating a number of different merge documents.
#How to mail merge labels from excel to word 2013 video download
If you find an updated template, download it to your computer and save it in the C:\Users\\AppData\Roaming\Microsoft folder, so Word will know where to find it. You can go to the label manufacturer’s site and search for the specific labels you seek. If you don’t see the template of the merge document you need, you can try going outside of Word 2013 and searching online for the template you’re looking for. Word displays a collection of current templates you can then click and download to your computer.įigure 1 Word 2013 includes many different merge templates you can tweak to fit your merge project needs. If you want to find label templates, type labels in the search box. Start by launching Word 2013 and in the Start screen, type merge in the search box, and tap or click Search ( Figure 1). Word 2013 comes with a number of mail merge templates you may be able to use or adapt to fit your merge project, whether you’re creating customer letters, mailing labels, or customized documents using product information and other variable data.
#How to mail merge labels from excel to word 2013 video how to
And you’ll even learn how to save it all and use it again so you don’t have to start from scratch next time. This article offers a number of tips and tricks to help you put together, merge, and troubleshoot your merge projects without a lot of hassle. And if you work with huge data lists with lots of data fields that you need to include somewhere-on the letter, on the form, on the labels-you may be tied up in knots about how to get all the fields you need into the space you’ve got.
![how to mail merge labels from excel to word 2013 video how to mail merge labels from excel to word 2013 video](https://i.ytimg.com/vi/zHJmabz4mLc/maxresdefault.jpg)
If mail merging isn’t something you do often, you may find yourself struggling to remember what goes where, when.
![how to mail merge labels from excel to word 2013 video how to mail merge labels from excel to word 2013 video](https://www.lifewire.com/thmb/cMGDqkOPl7jZM5LUnoy30SP06Hs=/1920x1025/filters:no_upscale():max_bytes(150000):strip_icc()/LabelsExcel4-0f0345eb0cd14b6da7728e98c839b7ed.jpg)
When you mention the words “mail merge” to Word users, the majority of them groan.
#How to mail merge labels from excel to word 2013 video windows
Doug Robbins' Windows Live SkyDrive page at.Do read the tutorial before trying to use the mailmerge document included with it.įor some recent, worked examples, see the attachment to the posts at:Īlternatively, you may want to try a Many-to-One Mail Merge add-in from either: The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). Hi I am an independent advisor and hoping to help you today.