Case Problems

Wheeling Vacations

Joan has received several inquiries about her planned biking tour of Morocco. Now that she knows she will have enough interest to finance the tour, she gets down to the business of planning the actual tour. She must first notify those that responded in time to be included. Assume the role of Joan and perform the steps she identifies. You may want to reread the chapter opening before proceeding.

1. After starting a new document, Joan launches the Mail Merge wizard and specifies that she’ll be creating letters. Next, she specifies that she’ll use the current document (which is currently blank) as her starting document.

2. Joan must now select recipients. She selects to type a new recipient list and proceeds with creating it. Joan decides to include the following fields in the data source: Title, First Name, Last Name, Address, City, State, and Zip. She customizes the data source accordingly.

   Joan adds the information for the six people who will accompany her and her husband to Morocco. (You can simply make up this information.) Save the resulting data source as "morocco.mdb" to your personal storage location.

   Once the Mail Merge Recipients dialog box appears, she clicks the OK command button to proceed. At this point, even though it is blank, Joan saves the main document as "Notification Mailing" to her personal storage location and leaves the document open for the next exercise.

3. In her main document, Joan creates the letter pictured in Figure 7.4.

Figure 7.4 Merged document

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=gif:: ::/sites/dl/free/0072471026/26780/WCh07_acq_Image6.gif','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (3.0K)</a>

Joan merges the letters to a new file that she saves as "merged notification mailing". After closing the document window containing the merged letters, she saves the main document as "revised notification mailing" to her personal storage location. She keeps this document open for use in the next exercise.

4. The "revised notification mailing" document is still displaying in the document window. Joan decides to create mailing labels using the attached data source. To do this, she clicks the Main Document setup button (<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=gif:: ::/sites/dl/free/0072471026/26780/WCh07_acq_Image7.gif','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (0.0K)</a> ) on the Mail Merge toolbar. The Main Document Type dialog box appears, as shown in Figure 7.5.

Figure 7.5 Main Document Type dialog box

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=gif:: ::/sites/dl/free/0072471026/26780/WCh07_acq_Image8.gif','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (3.0K)</a>

Joan selects the Labels option button and then the "Avery standard" label product and the "3261R - Return Address" product number. After clicking the OK command button in this dialog box, a warning dialog box appears. Joan clicks the OK command button to proceed.

At this point, Joan launches the Mail Merge wizard and proceeds to step four to arrange the labels. She previews the labels and then saves them to her personal storage location as "Notification Labels" before closing the document window.