Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your mail merge.
As a result, we’re going to show you how to make one page landscape in Word using a couple of tricks.Here are some tips to prepare your Excel spreadsheet for a mail merge. Doing so, however, isn’t as easy as you might expect. Sometimes, though, you want a single page landscape – to display an image for example. Most of the time when you create a Word document, you want it in either landscape or portrait. You can use the concatenate command to combine text cells in Excel without data loss.Įxtra: How to Make a Page Landscape in Word Thankfully, though, this doesn’t always need to be time-consuming. If you’ve spent much time in Excel, you’ll know the pain that comes with creating a large spreadsheet, only to realize it needs adjusting. Remember to save the document in case you need to reprint any of them.Įxtra: How to Combine Text Cells in Excel
With all of your addresses imported, you can finally print your labels and send off your mail.
This will help you to match your fields to the correct columns later on.įor example, in ours we’ll be using the fields property name, operator name, address, city, state, zip code, and country. The important thing to remember is that you must create a column header noting the information that will go in each heading. If you don’t have one, you can create one now. Before you can create labels from Excel, you’ll need your existing mailing list in the application.