Success Gardens Business Letters & Envelopes

Description

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 a database, modify a form 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

Club_Information

Contacts_Letter

You will save your files as:

Lastname_Firstname_Garden_Clubs

Lastname_Firstname_Club_Information

Lastname_Firstname_Contacts_Letter

Lastname_Firstname_Club_Letters

Lastname_Firstname_Club_Envelopes

Part 1

Open the Garden_Clubs database, and save it as Lastname_Firstname_Garden_Clubs

Create a form based on the Garden Clubs table, and save the form as Lastname Firstname Clubs Form

Enter the information below, using your First Name and Last Name for the last record.

Update the Address Field for the Evergreen Gardeners to 4525 Center Ave

Delete the record for Velvet Gloves.

In the table, apply Best Fit to all columns.

Club Name

First Name

Last Name

Address

City
State
ZIP
Phone
E-mail Address
High Rise Garden Path

Curtis

Guilliard

3931 Wallace

Houston

77004

713-555-5771

Curtis@successmail.com

Harris County Green

First Name

Last Name

7847 Faith Ave

Houston

77004

713-555-4774

Firstname@successmail.com

Part 2

Export the table as an RTF file named Lastname_Firstname_Clubs_RTF

Open the Club_Information file.

Insert the RTF file

Delete the Address, City, State, and ZIP fields.

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

Part 3

Open the Contacts_Letter, and save it as Lastname_Firstname_Contacts_Letter

Using mail merge, include appropriate merge fields from the Garden Clubs table in the database in the letter.

Complete the merge, and then save the merged letters as Lastname_Firstname_Club_Letters

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

3 attachments

Slide 1 of 3

attachment_1

attachment_1
attachment_2

attachment_2
attachment_3

attachment_3

Unformatted Attachment Preview

Success Gardens
14122 N 123rd St
Houston, TX 77004
713-555-0030
TO:
FROM:
DATE:
SUBJECT
Michelle Johnson, President
Dan Smith, Manager
August 5, 2019
Garden Clubs
Kendra Jones, Odis Charles, and I have been working with local gardening clubs
we want to feature on the Success Gardens. We are impressed with the
innovative and creative gardeners we have met and are excited to introduce them
to our gardening audience.
Following is a list of clubs that we have contacted:
Success Gardens
14122 N 123rd St
Houston, TX 77004
713-555-0030
August 5, 2019
SUBJECT:
Garden Clubs
Thank you for taking time away from your garden last week to visit with Kendra
Jones, Odis Charles, and myself about your wonderful garden club. We are
impressed with the inventive and imaginative gardeners in your club.
As we mentioned, we would like to introduce your club to our gardening audience
at Success Gardens. I will be calling you next week to confirm a date that works
for your club members.
In the meantime, if you have any questions, please don hesitate to give me a
call.
Sincerely,
Dan Smith
Manager
ID
Club Name First Name Last Name Address City
1 Rose Arms Annette Diamond 14161 N. Main
Houston
St
2 Houstons Xeriscapers
Ellen
Mitchell 1062 N. 43rd
Houston
Ave
3 DownsouthGloria
Garden Club
Willis
8417 S. 185th
Houston
St
4 Green Thumbs
Mary
White
12138 RoseHouston
Ave
5 Garden ClubRobert
of Pearland
Dada
14019 E. Dasis
Houston
Ave
6 Evergreen Gardeners
Brandon Redd
4732 Play DrHouston
7 Velvet Gloves
Allen
Glover
3048 Viola Dr
Houston
8 Lonestar Gardener’s
Shawn Club
Davis
19502 S. Main
Houston
Ave
9 Ft Bend County
Curtis
GardenGuillird
Club
3931 Wallace
Houston
Dr
10 Houston Garden
Melanie
Path Frank
6127 FanninHouston
Ave
11 High RIse Garden
Alma Club Savion
2743 GainesHouston
Ave
12 Harris County
Terry
Green Thumb
Pride Club 7847 Faith Ave
Houston
State
TX
TX
TX
TX
TX
TX
TX
TX
TX
TX
TX
TX
Zip
Phone .
77004 713-555-7171
77004 713-555-0488
77004 713-555-3021
77004 713-555-0195
77004 713-555-5356
77004 713-555-3999
77004 713-555-0481
77004 713-555-6111
77004 713-555-5771
77004 713-555-4322
77004 713-555-4721
77004 713-555-4774
E-mail Address
Annette@successmail.com
Ellen@successmail.com
Gloria@successmail.com
Mary@successmail.com
Robert@successmail.com
Brandon@successmail.com
Allen@successmail.com
Shawn@successmail.com
Curtis@successmail.com
Melanie@successmail.com
Alma@successmail.com
Terry@successmail.com

Purchase answer to see full
attachment

Explanation & Answer:

5 pages

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}