Microsoft Word: Advanced Mail Merge
Microsoft Word Training Series | Level 3
Duration: 1/2 day
Microsoft® Word® Versions: 2007 | 2010 | 2013 | 2016 | 365
Delivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC) on request
Course Fee: $175 CDN per person + HST or BYOD (bring your own device): $125 CDN person + HST*
Note: Public scheduled dates for this course are delivered as live instructor-led classroom training.
This course is designed for the user who needs to move beyond the basics and use Microsoft Word’s mail merge feature for more complex merges. Students will learn to merge letters, labels, catalogues and emails with multiple data sources including Excel worksheets. Various fields will be used to create merges and students will also learn to filter records using multiple criteria.
Prerequisite: Microsoft Word: Intermediate / Advanced or equivalent knowledge and skills.
Custom training: This course may be delivered at your site or ours as an instructor-led or virtual classroom solution. Contact us at email@example.com for more information including savings for custom group training.
Related training: View all Microsoft Word courses
INCLUDED IN THIS COURSE
- Comprehensive course manual
- Keyboard shortcuts quick reference
- Sample and exercise files
- Refreshments (for classes conducted in Avantix Learning classrooms)
- Follow-up email support
Overview of the Mail Merge Process
- Designating a main document and linking to a data source
- Inserting merge fields
- Creating a mail merge using the mail merge wizard
- Merging to a new document or print
- Generating letters, labels and envelopes
- Saving the main document
- Using a Word table or delimited Word document as the source
- Merging with an Excel worksheet or named range
- Using an Access database table or query as the source
- Changing the data source
- Applying filtering to customize the source records
- Using different operators for filtering records
Working with Field Codes
- Showing/hiding field codes
- Inserting other fields such as IF to run a custom mail merge
- Using the Next Record and Fill-In fields
- Changing the format of numeric and date data using field switches
- Using notes in a mail merge
Register Now for a public course at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.
Updated January 2, 2017.
Copyright 2014-2017 Avantix Learning Inc.
To request this page in an alternate format, contact us.
*Prices subject to change..
You may like
You can keep text together in several ways in Word. If you want to keep words or characters together, you can use nonbreaking spaces or nonbreaking hyphens or dashes and insert them using a dialog box or a keyboard shortcut. If you want to keep lines or paragraphs together on the same page, you can apply settings in the Paragraph dialog box (which can be built into styles if you use styles).
You can insert the does not equal sign (not equal to sign) in a Word document using Insert Symbol, a keyboard shortcut, an AutoCorrect entry or an Alt shortcut.
You may also like
During a PowerPoint slide show, you can change your mouse into a laser pointer to focus attention on a specific area on your slide. You can show or hide the built-in laser pointer using keyboard shortcuts or by using the context menu.
You can add audio in PowerPoint from a file on your PC or from a shared drive. Audio is played during a slide show and you can insert music, sound clips, or voice recordings. Since audio files are copied into PowerPoint presentations by default, they can increase file size and may need to be compressed. To play audio, your computer must be equipped with a sound card and speakers.
Check out these three easy ways to copy shape, picture or text formatting quickly and easily in PowerPoint using buttons or keyboard shortcuts.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | firstname.lastname@example.org