Join Gini von Courter for an in-depth discussion in this video Understanding Mail Merge, part of Word 2010: Mail Merge.
In mail merge, we take a primary document, for example, a letter like this one,…then insert structured data, a table or list from a database, an Excel…spreadsheet, or Outlook contacts, to create multiple personalized letters, such as…individually addressed documents.…In Word, mail merge requires two files.…The first file is a Word document that contains the information that will be the…same in every letter, and the instructions on where to place the variable data.…The second file is a data source, which could be, again, an Excel worksheet, a…database, an Outlook address book, or a table that was created in another Word document.…
We'll use the commands on the Mailings tab of the Ribbon to merge these two…files together to create the personalized documents.…Mail merge isn't just for letters;…we can also merge labels, including mailing labels and name tags.…By combining Word with Outlook, we can also use mail merge to create…customized e-mail messages.…Each recipient receives a personalized message that's sent only to them.…
AuthorGini von Courter
- Choosing or creating a data source
- Using Mail Merge with Outlook contacts
- Merging data from an Excel spreadsheet
- Inserting address blocks and greetings
- Matching fields from a data source
- Previewing merge results
- Using rules for customized merges
Skill Level Intermediate
Excel 2010: Tips, Tricks, and Shortcutswith Dennis Taylor3h 43m Intermediate
1. Creating Personalized Letters
2. Creating Other Types of Merged Documents
3. Using Rules for Customized Merges
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
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.