Join Gini von Courter for an in-depth discussion in this video Prompting for repeating input with ASK, part of Word 2010: Mail Merge.
The Microsoft Word merge field Ask is similar to Fill-in, but it has a couple of…different behaviors.…Fill-in takes a piece of data entered by the user and sticks it into each letter.…Ask creates a bookmark to hold the text temporarily and stores that user-entered…value in the bookmark.…Then you add a corresponding Ref field, a reference field, that says go grab the…value that the user put in that bookmark and stuff it into the letter where I…place the Ref field.…
Here is why we will use Ask.…The location of the meeting occurs twice in the letter.…The first time it's listed in paragraph one, the second time in paragraph three.…Now if we were lazy, we could use Fill- in and say location one, location two and…enter the same information twice, but if we misspell it once, it's going to look icky.…We're going to use the Ask field to ask the user at the time of merge, where is…the meeting going to be held?…Then we'll drop in two reference fields to drop that information into the letter twice.…
The only part of this that we care about, in terms of a sequence, is that the Ask…
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.