Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Prompting for individual input with FILLIN

From: Word 2010: Mail Merge in Depth

Video: Prompting for individual input with FILLIN

In the previous two videos, we've used Microsoft Word's Ask and Fill-in fields to collect information from the user at runtime to insert into the letter about the location of our meeting, the date of the letter, and the date of the meeting. We are left with one piece of information that we need to provide at runtime, but it's different for each and every recipient. That's the role of that recipient we will play in the meeting, highlighted here in teal. For our team, we have three basic roles. We have the role of the convener, we have the role of the recorder, and we have a role for a timekeeper. Everyone else is an observer.

Prompting for individual input with FILLIN

In the previous two videos, we've used Microsoft Word's Ask and Fill-in fields to collect information from the user at runtime to insert into the letter about the location of our meeting, the date of the letter, and the date of the meeting. We are left with one piece of information that we need to provide at runtime, but it's different for each and every recipient. That's the role of that recipient we will play in the meeting, highlighted here in teal. For our team, we have three basic roles. We have the role of the convener, we have the role of the recorder, and we have a role for a timekeeper. Everyone else is an observer.

So, what we'd like to do is, at the time we do the merge, be prompted to determine the role for each of our team members at this specific meeting. We're going to use a variation of the Fill-in field to be able to do this. So, let's start by deleting this information here for the observer, and now we'll use Rules > Fill-in and say, "Enter the meeting role." Now, the Default role is observer, so we could simply enter that here.

We're not going to click the Ask once check box. We are simply going to leave it, because we want to be asked for every single recipient, and we are going to click OK. We will, of course, be prompted, right away, and enter observer, and that information will be entered here, and we can see that we need to enter a space. Now, don't forget, you can use Alt+F9 to see the field codes that are already here, and Alt+F9 to hide them again. Let's go ahead and see how our merge works, and I will tell you ahead of time that this will be an unsatisfactory experience, because as we merge through and say that we want to merge all the records, we'll be prompted for a location, and we'll put Tahiti and say OK and then the mailing date for the reminder and the meeting date itself, then it says, Enter the meeting role, and we say, hmm, for who? We will be prompted over and over again to enter the meeting role.

It doesn't matter whether we say OK or Cancel; we'll be prompted. I'm just thankful that we didn't have 500 records, or we'd be clicking OK 500 times right now. So, how do I get information about what letter I'm on? Well, let's close this merge results and not save it and return to our primary merge file we are building, and let's go back and take a look at the field code for observer here. We are going to hold Alt and hit F9, and it says, Enter the meeting role. We want to add the merge field that gives us the person's first name, and it is absolutely critical that it go inside the prompt.

The prompt starts after the word "FILLIN" and after the quotes and ends with the other set of quotes. So, I'm going to say Enter the meeting role, space, for, and then I am going to insert the merge field to pick up that person's name. First, space, and even the Last name. So, now my prompt in quotes is Enter the meeting role for First, Last. This /d is the default, and it will put the observer in, and then this MERGEFIELD first comes from our original merge that's dropping the recipient's first name right here.

So, it says, Thank you for agreeing to serve as your role for the meeting ,first name. I think we are all set. We've built this out, so that we can actually see where we are. Let's go to Finish & Merge > Edit Individual Letters, and let's go ahead and just do the first three letters so we can see what they look like. It says, where is the location for the meeting? Tahiti, OK. The mailing date for the reminder the 26th of August. Well, we might get it done a day early. Let's go ahead and mail it, if we could, on the 25th, and say OK.

The meeting date hasn't changed from September 22, and now it says Enter the meeting role for Pam Shepherd. Well, Pam has agreed to be our Timekeeper, and we'll say OK. Then Enter the meeting role for Tyrone Woods. Well Tyrone is the Convener for this meeting, OK. Keisha is an Observer, and we'll say OK. So, you notice for each person, we are getting prompted. There we have Pam the Timekeeper, Tyrone the Convener for the meeting, and Keisha who's going to be an Observer.

So, by using the Ask field, or the Fill- in fields, but also including the merge fields in the prompts, we can be prompted, as we go through the merge, to provide very specific, individualized information for each and every recipient. I am going to go ahead and close these merge results and not save them, return to the Mailings tab, and let you have one more look at where we inserted the name inside of the quotes as part of the prompt for the Fill-in fields. Remember, Alt+F9 exposes all of these field codes for you to be able to go in and look, and also to edit them.

By using Ask and asking with every letter, we can enter variable information on the fly, rather than needing to build it into our data source.

Show transcript

This video is part of

Image for Word 2010: Mail Merge in Depth
Word 2010: Mail Merge in Depth

23 video lessons · 11456 viewers

Gini Courter
Author

 

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

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.


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.

Join now "Already a member? Log in

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
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.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

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
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.