Use “friendly” column headers such as First Name, Last Name, Address, and City instead of Column 1, Column 2, Column 3, and Column 4.When setting up your address list in Excel, consider the following tips: Each merge field corresponds to a piece of the address on the label-first name, last name, street address, and so on. Word pulls out the information in your Excel columns and plugs it into the corresponding merge fields, with an end result that looks something like this: The key thing to understand is that your column headers, or categories, in Excel will become merge fields (placeholders) in Word. If you get this part of the process right, things will run more smoothly when you’re setting up your labels in Word. This post is about that first step-the one where you prepare your address list in Excel so that you can use it in Word. Learning how to make your Excel address list magically show up on your sheets of labels boils down to five basic steps: And if you create labels infrequently, it’s hard to remember what to do and what to watch out for. This should generate, whether the merge would involve single or multiple records, and whether the result should be a single document for each record, or all records in one document.Hey, the holidays are fast approaching, which means you’ve got to get your cards signed, sealed, and delivered! This post goes out to those of you who keep your address list in Excel and need to figure out how to use it to create mailing labels in Word.Ĭreating labels can be intimidating, mainly because there are a number of intricate steps to follow and you’re typically working with different programs-in this case, Excel and Word. Beyond that, in order to offer suggestions it would help to know a bit more about the type of document If you want to roll your own, I'd consider using content controls as the 'data targets'. Then you only link up to the real data while executing the actual merge and immediately unlink it after the merge has been executed. So that the user can insert the merge fields. So you will need to create your own 'mail merge' interface. OR you create a data-subset, for example a comma-delimited text file with the field names and a single row of mock-up data, That's simply the way it is and there's no way to change that. Not be possible for the built-in mailmerge functionality.

Mail merge microsoft word 2011