In the Mail Merge Manager, click Select Document Type and then choose Create New→Labels. From the Label Products pop-up menu, choose the product. From the Product Number list, select the correct number for your labels. Click OK to close the Label Options dialog. A table appears. Don’t make any adjustments to the table or click in the table. Whether you're new to mail merge, or have already created many merge documents, this course will take you on an ever deeper dive into the power of Microsoft Word 2016 for Mac.
They might probably work in Word 2007 as well, though I have not tested in lower versions and cannot state this with certainty: ) Shortcut Description Alt+F9 Switch between all field codes and their results in a mail merge document. Shift+F9 Expose the coding of the selected field. F9 Update the selected filed. Place the cursor anywhere in the field and press F9 to update it.
An alternative is to make an image of the whole postcard in PPT as an image, minus the fields for address, etc. Insert that image in the mail merge doc. Send the image to the back layer. Position mail merge fields where you need them with the postcard image effectively 'the background'.
Type the text as you usually do in a Word document or copy/paste from an external source. • Add placeholders. Now you need to add placeholders for the Address Block and Greeting Line for Mail Merge to know exactly where to add the data. To add a placeholder, click the corresponding button on the ribbon Mailing > Write & Insert Fields.
For each person who gets a form, I want the various fields to be located in the same location on the form even though the data may be different lengths. 
I attempted to do this by making each field the same length for each person, adding spaces and a. To those that have shorter data.
When you're ready to print the queued labels, select the Print button from the upper right-hand corner of the window and a print screen will appear. Additionally, you can use one of the application's built-in label templates to create label, envelope, and postcard designs from scratch. When at the home-screen, click into the Labels, Envelopes, or Postcards menu — all of these are located to the right of the Design button. When in these menus, you can select which label template you'd like to use to create your new design. Labels & Addresses has hundreds of templates built-in, including templates for Avery and DYMO labels amongst other brands.
I'll demonstrate how you can connect Word for Mac to data that you already have stored in Outlook, Excel, or FileMaker Pro and use fields from these data sources and others in your letters or email messages. You'll see how to use rules fields in your primary merge file, so that you can use one file to do the heavy lifting of many different mail merge files and I'll show you how to troubleshoot some of the common issues that arise with mail merge so that you can tweak a file or a few settings and complete your project. Whether you're new to mail merge, or have already created many merge documents, this course will take you on an ever deeper dive into the power of Microsoft Word 2016 for Mac. Thank you for joining me, let's • Practice while you learn with exercise files.
That works brilliantly. Thanks for the tip! I also just discovered how to put both text and a formula into the same cell.
Excel Mail Merge Tutorial
The field will be permanently removed from a document, replaced by its current value and from then on treated as normal text. Alt+Shift+d Insert the DATE field that displays the current date. Alt+Shift+p Insert the PAGE field that displays the page number. Alt+Shift+t Insert the TIME field that displays the current time. Alt+Ctrl+l Insert LISTNUM field. Hopefully, this information has been helpful and now you know how to perform mail merge in Excel and Word properly. In the next article, we will investigate how to quickly.