Otter Bay Kayaking Adventures Every day during the summer season, tourists from the many cruise ships that sail into Juneau book tours with Otter Bay Kayaking Adventures.

As an assistant in the Marketing Department, you are responsible for corresponding with cruise ship companies to make requests, confirm tour arrangements, and transmit sales literature. To complete this case study, you write a form letter to confirm tour arrangements, create a data source containing information for two recipients of the form letter, and run a mail merge to produce two confirmation letters.

1. Start a new blank document and save it as Kayaking Tours Confirmation Letter.

2. Format the letter using the Full Block format, include the current date, and create an attractive letterhead. The information is: Otter Bay Kayaking Adventures, 149 Seward Street, Juneau, AK 99804, Phone: (907) 555-3311, Web site:

www.otterbaykayaking.com.

3. Note that you can use the Line spacing button in the Paragraph group on the Home tab to change the line spacing of the letterhead to 1.0 and remove after paragraph spacing.

4. Write a draft of the form letter that you would send to the cruise ship tour coordinators to confirm arrangements for an adventure tour. Include the following information in your letter:

a. Your company offers two adventure tour options: Half Day Sea Kayaking and Full Day Whitewater Rafting.

b. The letter should include placeholders for the name of the cruise ship, the number of guests, the tour name, the tour date, and the tour cost.

c. The first paragraph of the letter should thank the cruise ship for registering passengers for one of the two tours.

d. The second paragraph should provide additional details, such as the number of guests, the tour date, and the tour cost. You can display this information in the form of a list if you wish.

e. The last paragraph should provide contact information and should close positively.
5. Include your name in the closing of the main document and save the document.
6. Open the Mail Merge task pane, and then create a data source that contains only the field names you need for your letter. Note that you will need to delete field names you will not use and present the field names in a logical order. You will need to add some field names. Be sure to keep all the field names you will need for the Address block.
7. Enter information for two cruise ships in your data source.
8. Save the data source as Kayaking Tours Data, add field names to the document, review the letters, and then make adjustments to the main document and data source if necessary.
9. Save the merged document as Kayaking Tours Confirmation Letter Merged, print a copy of the two letters, and then in the main document, deselect Preview Letters and save and close the document.