Join Gini von Courter for an in-depth discussion in this video Opening an existing File, part of Word 2010: Mail Merge.
When you create a new mail merge letter, eventually you have to close it, so…you'll want to reopen it again, and when you do, you're going to be prompted.…And I'd like to show you the prompts you're going to see so that you understand them.…You don't need to try to follow along with this; just watch and I'll try to go…through it fairly quickly, so that you can see how this works.…Whether I double-click to open a file in a folder or I go to Word backstage and…choose to open a folder,…when I open a mail merge letter, as soon as Word starts to open it, the letter says, hey!…wait a second; I'm connected to a data source somewhere else.…
And so Word then will prompt you to say, do you know that this letter intends to…go grab some information from a data source?…It says, opening this letter will run the following SQL command, and it shows you…a SQL Select statement. Don't worry about that.…Basically, what it's saying is it's going to a database.…Now if you've already set up a data source and connected to it, even if you…
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.