Start learning with our library of video tutorials taught by experts. Get started

Word 2010: Mail Merge in Depth
Illustration by Neil Webb

Prompting for repeating input with ASK


From:

Word 2010: Mail Merge in Depth

with Gini Courter

Video: Prompting for repeating input with ASK

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.

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
Please wait...
Word 2010: Mail Merge in Depth
1h 31m Intermediate Sep 10, 2010

Viewers: in countries Watching now:

In Word 2010: Mail Merge in Depth, author Gini Courter demonstrates how to take advantage of Word's Mail Merge feature to save a tremendous amount of time creating customized documents. The course offers tutorials on creating letters, emails, envelopes, and labels. It also shows how to use Mail Merge with Outlook and Excel, creating data sources, inserting fields, using IF and other rules for customized merges, and troubleshooting Mail Merge issues. Exercise files are included with the course.

Topics include:
  • 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
Subject:
Business
Software:
Word
Author:
Gini Courter

Prompting for repeating input with ASK

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 field has to be placed in the letter prior to any reference to the Ask field. So I'll generally go right to the top the letter and do something like Ctrl+Home to get as high in the letter as I can before we place this Ask field in our letter. So we're going to go ahead and on the Mailings tab in the Write & Insert Fields area, we're going to choose Rules > Ask. It says Insert Word Field: Ask. This is for the meeting location. So we give the bookmark a name, Location.

And because it will be the same for every letter, we're going to send everybody to meeting in the same place, we're going to only ask once. The prompt will be Enter the location for the meeting. Now if most meetings are held at Corporate Headquarters, we could put that in this default bookmark text. So, let's just go ahead and say most meetings are there. So we'll put in a bookmark. That's a default. If I don't enter anything else, it will say Corporate Headquarters. Let's go ahead and say OK, and we will be prompted, and we'll say, okay, the meeting is going to be at Corporate Headquarters, and say OK.

Now, absolutely nothing happens, except that value has been stuffed into a bookmark. We now need to place two reference fields to reflect that information back in the document. The first will go here. So I'm simply going to delete where it says Corporate Headquarters. You'll notice, if we look at the rules list, there is no reference here. This is a field that's not included on the default list of merge fields. To go get it, we'll have to go to the Insert tab. So let's go to Insert > Quick Parts > Field to open the list of all the fields that are available to us when we work automating Word.

As I scroll down the list, you'll find Ref here, which is a reference, and it says, okay, if you're going to insert a reference, what bookmark are you referring to? I'll say location. Now notice that I need to be at the right place in my letter in order to do this, because it's going to insert the reference right where I am. There are number of different options I can use. For example, I can have users enter a value, and then I can format it in the way I choose. I can have incrementing numbers that appear, but I just want to grab this reference and stuff it back in the letter.

If you want to look at these other options, I recommend them to you, because you can do some exciting things with them. I am going to say OK, and notice Corporate Headquarters got dropped there. And I can tell I need a space here, so I am going to put space. Let's go add a reference for the second time that this appears. I am going to simply select this text and delete it, Insert > Quick Parts > Field, scroll down to Ref, or hit R to get down there quicker, Location > OK, Corporate Headquarters again, and add my space in the letter.

That's all the harder it is to be able to use Ask and Ref together to be able to insert information here in my merge letter. Now, I want to show you one other thing, as we start adding these fields in. There is a shortcut key that you can use to see the fields. It's Alt and then F9. So when I do Alt+F9, I'll actually see all of the fields that are in my letter, and that's helpful. Here's the Ask that I did. Ask for a location. There's the prompt. There's the default, followed by the Fill-in, which was to fill in the date for the meeting.

We did that in an earlier video. Then down in the text, notice in the body, a reference to location, a reference to location. When you simply highlight the merge fields, those Ref and Ask fields won't show up. So you'll want to remember that Alt+F9 will display or hide all of those field codes. Let's go ahead and save our letter. I am going to do File > Save As, and I am going to save this as Cover Location. Now let's merge this and see how it actually works.

Remember that if you weren't with us in the last video, we were prompting for a couple Fill-ins as well. So Edit Individual Documents > Merge them all. It says, where is the location for this meeting? I am going to say Bali, because we deserve it, actually, Tahiti, because my friend Jeff likes going their. So we're going to choose Tahiti and click OK. This is a Fill-in the date for the meeting. August 24 is fine. Fill-in the date here, and now we've picked up the date, but also Tahiti is going to appear in two locations in every single letter.

There's our first letter, as we scroll down, our second letter. So we can use Ask to grab information and place it as many locations as we wish in a document. Think about using Ask for things like contracts, where you need to fill in information about both parties in a contract. By using Ask, we can allow the user to enter variable information on the fly at the start of the mail merge, rather than having to enter all of this information in the data source.

And this makes Word mail merge very, very powerful.

There are currently no FAQs about Word 2010: Mail Merge in Depth.

Share a link to this course
Please wait... Please wait...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Upgrade now

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.


Mark all as unwatched Cancel

Congratulations

You have completed Word 2010: Mail Merge in Depth.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Welcome to the redesigned course page.

We’ve moved some things around, and now you can



Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked