Word: Mail Merge in Depth (2019)
1h 40mIntermediate2019-05-13
Authors
Gini von Courter
Teaching computer classes on Microsoft Office for 20+ years
Course details
Discover how to use the popular mail merge feature to quickly build customized emails, labels, letters, and other documents. In this course, Gini von Courter shows you everything you need to know to use Mail Merge with ease. Gini begins by demonstrating how to set up your data file, either by creating one from scratch or by connecting to files in Excel, Outlook, and Access. Then, she shows how to build your template, including how to use the If…Then…Else function. She also covers setting rules for advanced mail merges and troubleshooting problems.
Note: This course was recorded in Office 365, but users of Office 2019, Office 2016, and some earlier versions will find plenty of relevant content.
Learning objectives
Choosing or creating a data source
Using Mail Merge with Outlook contacts
Mail merging data from an Excel spreadsheet
Inserting address blocks, greetings, and other fields
Matching fields from a data source
Previewing merge results
Sending merged email
Creating labels with images
Using rules for customized merges
Note: This course was recorded in Office 365, but users of Office 2019, Office 2016, and some earlier versions will find plenty of relevant content.
Learning objectives
Choosing or creating a data source
Using Mail Merge with Outlook contacts
Mail merging data from an Excel spreadsheet
Inserting address blocks, greetings, and other fields
Matching fields from a data source
Previewing merge results
Sending merged email
Creating labels with images
Using rules for customized merges
Skills covered
Word ProcessingMicrosoft WordEmailOffice 365Microsoft 365Business Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Create custom documents quickly with mail merge
1. Set Up Documents and Data Sources
- 02 - Word mail merge - The basics
- 03 - Start a simple mail merge document
- 04 - Choose a data source
- 05 - Use mail merge with Outlook contacts
- 06 - Create a new data source for mail merge
- 07 - Merge with an Access table or query
- 08 - Merge with Excel data
2. Insert Fields and Merge
- 09 - Match fields from the data source
- 10 - Insert address blocks, greeting lines, and merge fields
- 11 - Simulate the merge
- 12 - Complete the merge
- 13 - Open a mail merge primary document
- 14 - Troubleshoot mail merge
- 15 - Fix numeric formatting in the data source
- 16 - Apply numeric formats in Word
- 17 - Apply date formats in Word
3. Email Merge
- 18 - What email merge can do for you
- 19 - Create personalized email messages
- 20 - Go offline to merge email messages
- 21 - Finish the email merge
- 22 - Attach a Word document to an email message
4. Create Envelopes, Labels, and Directories
- 23 - Create envelopes
- 24 - Create labels
- 25 - Add an image to each label
- 26 - Create a directory
5. Use Rules and Other Advanced Features
- 27 - Prompt for global input with FILLIN
- 28 - Prompt for individual input with FILLIN
- 29 - Prompt for repeating input with ASK
- 30 - Use an If-Then-Else rule for intelligent merging
Conclusion
- 31 - Next steps