![office 2016 mail merge not lining up correctly office 2016 mail merge not lining up correctly](https://venturebeat.com/wp-content/uploads/2018/06/IMG_1229.jpeg)
Connect and edit the mailing listĬonnect to your data source. Before printing, double-check that it worked okay by choosing 'Edit Individual Labels' > 'Merge All' to preview the labels and make sure that 'Update Labels' took. The Excel spreadsheet to be used in the mail merge is stored on your local machine.Ĭhanges or additions to your spreadsheet are completed before it's connected to your mail merge document in Word.įor more information, see Prepare your Excel data source for mail merge in Word. Select 'Update Labels.' Then you can go back to your to the Wizard and finish things up. STEP 4: Drop in the Values field (SALES) in the Values area once again. For example, to address readers by their first name in your document, you'll need separate columns for first and last names.Īll data to be merged is present in the first sheet of your spreadsheet.ĭata entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values. STEP 1: You will need to enter a value or a zero within this blank or text formatted cell (s) STEP 2: Go over to your Pivot Table, click on the Count of. So, before you continue to the fix below, try the following steps: Step 1.
![office 2016 mail merge not lining up correctly office 2016 mail merge not lining up correctly](https://venturebeat.com/wp-content/uploads/2012/01/macworld-crowd2.jpg)
#Office 2016 mail merge not lining up correctly how to
Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your mail merge. How to fix: Page preview and actual print dont match (Word 2013 & Word 2016) Print problems in Office or other programs, typically occur because of invalid printer drivers or a defective third-party add-in that affects the document layout. Here are some tips to prepare your Excel spreadsheet for a mail merge.