With Word mail merge it's easy to add a logo or other image to each merged label. In this video, learn how to insert a logo on participant name tags for a company meeting.
Resume Transcript Auto-Scroll
Author
Released
5/13/2019
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.
Topics include:
- 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
Skill Level Intermediate
1h 40m
Duration
17,146
Views
Show More
Show Less
Related Courses
-
Office 365 New Features (Microsoft 365)
with David Rivers1h 43m Intermediate -
Excel Quick Tips (2018)
with Garrick Chow26m 53s Intermediate -
Outlook Quick Tips
with Garrick Chow33m 46s Intermediate -
PowerPoint Quick Tips
with Garrick Chow24m Beginner
-
Introduction
-
1. Set Up Documents and Data Sources
-
Word mail merge: The basics2m 22s
-
Choose a data source3m 24s
-
Merge with Excel data2m 35s
-
-
2. Insert Fields and Merge
-
Simulate the merge2m 47s
-
Complete the merge4m 4s
-
Troubleshoot mail merge5m 23s
-
Apply date formats in Word1m 23s
-
3. Email Merge
-
Finish the email merge2m 34s
-
4. Create Envelopes, Labels, and Directories
-
Create envelopes4m 15s
-
Create labels3m 1s
-
Add an image to each label1m 35s
-
Create a directory5m 49s
-
-
5. Use Rules and Other Advanced Features
-
Conclusion
-
Next steps1m 47s
-
Show MoreShow Less
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Add an image to each label