Word mail merge from excel 2010
- WORD MAIL MERGE FROM EXCEL 2010 HOW TO
- WORD MAIL MERGE FROM EXCEL 2010 FULL
- WORD MAIL MERGE FROM EXCEL 2010 CODE
In the first step of the wizard, you select Labels and click Next: Starting document near the bottom. The Mail Merge pane will open in the right part of the screen. Head over to the Mailings tab > Start Mail Merge group and click Step by Step Mail Merge Wizard. Avery, then you need to match the dimensions of your Word mail merge document with the dimensions of the label sheets you are going to use. If your company already has a package of label sheets from a certain manufacturer, e.g. In Microsoft Word, create a new document or open an existing one. Not to mislead you, this information will be provided in (brackets).
Also, we'll point out where to find the equivalent options on the ribbon. To show you an end-to-end process, we are going to mail merge address labels using the step-by-step wizard. If you are pretty comfortable with the mail merge feature, you can use the individual options on the ribbon. It provides step-by-step guidance which may be helpful for beginners. There are two ways to do a mail merge in Word: The good news is that it's a one-time setup - all labels will be created in one go. With the Excel mailing list ready, the next step is to configure the main mail merge document in Word.
WORD MAIL MERGE FROM EXCEL 2010 HOW TO
WORD MAIL MERGE FROM EXCEL 2010 CODE
Format the Zip code column as text to retain leading zeros during a mail merge.For example, instead of a single Name column, you'd better create separate columns for salutation, first name and last name. Split the recipient information into very small pieces.Giving identical names to your Excel column will help Mail Merge to automatically match the fields and save you the trouble of mapping the columns manually. The screenshot below shows a list of the Address block fields used by Word.
WORD MAIL MERGE FROM EXCEL 2010 FULL
For address fields, use the full words such as Address, City, State, Postal or Zip code, Country or Region.
Microsoft Word will be pulling out the information from your Excel columns and placing it into the corresponding merge fields in this way:īefore starting a mail merge, invest some time in setting up your Excel spreadsheet to ensure it is properly structured. Or, it can combine several entries, for example the «AddressBlock» field. A merge field can correspond to one entry such as first name, last name, city, zip code, etc. In essence, when you mail merge labels or envelopes from Excel to Word, the column headers of your Excel sheet are transformed into mail merge fields in a Word document. The steps are essentially the same in Excel 2021, Excel 2019, Excel 2016, Excel 2010, and very similar in Excel 2007. Whatever intricate and intimidating the task may sound, it boils down to 7 basic steps.īelow, we'll take a closer look at each step using Microsoft 365 for Excel. If you've had a chance to read our Mail Merge tutorial, a larger part of the process will be familiar to you because making labels or envelopes from Excel is yet another variation of the Word Mail Merge feature.
The tutorial explains how to do a mail merge from an Excel spreadsheet for labels.