The scenario:
Success Gardens is planning to feature a garden club each week on its show and wants to invite garden clubs to apply. You have been asked to update the contact information for the clubs in an Excel workbook, modify the workbook including the contact information, and then create individualized letters and envelopes using mail merge.
For this assignment, you will need the following files:
New blank Word document
Garden_Clubs.xlsx
Club_Information.xdoc
Contacts_Letter.xdoc
You will save your files as:
Lastname_Firstname_Garden_Clubs.xlsx
Lastname_Firstname_Club_Information.xdoc
Lastname_Firstname_Contacts_Letter.xdoc
Lastname_Firstname_Club_Letters.xdoc
Lastname_Firstname_Club_Envelopes.xdoc
Open the Garden_Clubs.xlsx, and save it as Lastname_Firstname_Garden_Clubs.xlsx
Add the information below, using your First Name and Last Name for the last record.
High Rise Garden Path
Curtis Gailliard
3931 Wallace
Houston TX 77004
713-555-5771
County Green
First Name Last Name
7847 Faith Ave
Houston TX 77004
713-555-4774
Update the Address Column for the Evergreen Gardeners to 4525 Center Ave
Delete the row for Velvet Gloves.
Apply AutoFit to all columns.
Copy the contents of the Clubs Name Column
Open the provided file Club_Information.xdoc.
Paste copied contents into Club_Information document
Ensure the font and font size is the same through the letter.
Format the information sheet to display as a one-page document
Include a page color, page border, and theme.
Save the document as Lastname_Firstname_Club_Information
Open the Contacts_Letter.xdoc, and save it as Lastname_Firstname_Contacts_Letter
Using mail merge, include appropriate merge fields from the Garden Clubs Excel workbook in the letter adding the Name and address under date.
Update the date to the current date of this assignment.
Complete the merge, and then save the merged letters as Lastname_Firstname_Club_Letters.xdoc
Create envelopes to be used with the letters, using Success Gardens’ address as the return address.
Save the merged envelopes as Lastname_Firstname_Club_Envelopes
Insert your name in the footer for each of the Word documents.
