Join Gini von Courter for an in-depth discussion in this video Using Mail Merge with an Excel table, part of Word 2010: Mail Merge.
Most organizations maintain a lot of data in Microsoft Excel, and it's easy to see why.…Excel is incredibly powerful and yet simple to use when you want to enter, sort,…filter and analyze data.…Let's see how we can use Microsoft Excel as a data source for our mail merge.…We have our letter open, with the text that will be variable text highlighted.…Let's go ahead and open an Excel workbook.…We will go to Select Recipients > Use Existing List, and I am going to go open my…Exercises folder in Chapter 1 and select the Vendors Workbook.…
When I open the workbook, there are two different tables listed, but these…aren't really tables;…they are worksheets.…I know they are worksheets, because they have a dollar sign at the end of their…name, and it says that the first row of data contains column headers for both of these.…There are some column headers, so that's great. Now, I am going to open up this…first data set, which is called Current.…When I click on Edit Recipient List, you will notice that the Data Source is…
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?
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.