Learn how to use the Mail Merge Wizard to easily create a mail merge project. Author Jen McBee demonstrates creating a mail merge using an Excel file as the recipient list and inserting address blocks and greeting lines, skills you may need to demonstrate
- View Offline
- Exercise Files
- [Narrator] Creating a mail merge…is so much easier in Word 2010.…On the Word 2010 MOS exam, you will probably be asked…to start a mail merge, go in and select a recipient list,…edit the recipient list, insert an address block,…and insert a greeting line.…In this video, we're going to cover…all five of these options so you'll be well prepared…to tackle any mail merge tasks that come up on the exam.…I have the 08_01 exercise file open,…so if you're ready, let's do some merging.…
Here's the document that we're going to be sending…to all of our new customers.…And you'll see that there are some placeholders in here…where we need to swap out some of the fields…from our data source.…So first thing's first, let's go the Mailings ribbon.…Click on Start Mail Merge.…Now this is where you select if you're doing Letters,…E-mail Messages, Envelopes, or Labels.…We're doing a Letter, perfect.…The next step, we're just gonna go right…across the top here, Select Recipients,…we're gonna use an existing list.…
I have an Excel worksheet saved…
Explore the Microsoft certification program and then walk through all the exam objectives in detail. Learn about sharing and maintaining documents, formatting content, applying page layout and reusable content, including illustrations and graphics, proofreading documents, applying references and hyperlinks, and performing mail merge operations. Get hands-on experience with free downloadable practice files and take the challenges to test your skills. The course wraps with a full-length, 50-minute practice exam.
- Preparing for the exam
- Creating new Word documents
- Protecting and sharing documents
- Formatting content using font and paragraph attributes
- Creating tables and custom bullet characters
- Inserting breaks, headers and footers, and watermarks
- Adding and formatting illustrations, graphics, and SmartArt
- Creating Quick Parts from existing objects
- Proofreading documents and configuring AutoCorrect
- Applying endnotes, footnotes, and hyperlinks
- Setting up and executing a mail merge
- Taking a full-length practice exam
Skill Level Intermediate
1. Microsoft Office Specialist (MOS) Exam Overview
Prepare for the exam2m 49s
2. Creating, Sharing, and Maintaining Documents
3. Format Content
4. Applying Page Layout and Reusable Content
5. Including Illustrations and Graphics
6. Proofreading Documents
7. Applying References and Hyperlinks
Insert and edit hyperlinks4m 31s
8. Performing Mail Merge Operations
9. Practice Exam
- 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.Cancel
Take 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.