Join Gini von Courter for an in-depth discussion in this video Creating a new data source for Mail Merge, part of Word 2010: Mail Merge.
If the variable data you want to use for mail merge - names and addresses or…part numbers and inventory items, for example - doesn't already exist in any…electronic format, you can create a new data source for mail merge right here in Word 2010.…I want to start by stressing that you should not create a new data source if the…data already exists.…There is always a way to get the data to Excel or to Outlook so that you can use it.…However, if you have a stack of forms that people filled out and you need to…enter them somewhere, this is a great way to do it.…
We are going to choose Select Recipients on the Mailings tab in Word and then…choose Type New List.…When we do, the New Address List dialog box opens, and it's waiting for us to…enter some information, so we can easily do that.…We can enter all the folks that we need to send this letter to,…simply typing all the information.…You will notice we have fields for Address, City, State, ZIP Code, Home Phone,…Work Phone, Email Address, and then if we keep tabbing, it comes all the way…
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.