37
WRD
10
important NOTE
Priortocompletingthis
project,youmustfirst
complete"ProjectEXL-1:
BattleoftheBandsList"
intheMicrosoftExcel
sectionofthisbook.
your TASK
Your task is to create
a form letter to the
Battle of the Bands
entrants that have
been selected to
perform at the next
competition. Using the
Modified Block Style
Letter format, you will
merge this letter with
the data from the Excel
file that you completed
in Project EXL-1.
the SKILLS
· Formatamodified
blockstyleletter
· Usethemailmerge
featurewithanExcel
file
· Setatab
Modified Block Style Letter
A
ttimesitisnecessarytosendthesamelettertoseveralpeople.Usingthe
mailmergefeatureinMicrosoftWordmakesthisaneasytask.Merging
requiresaform(theletter)andadatafile(aspreadsheet,adatabase,ora
newlytypedlist).Thebenefitofmergingincludestimesavedtypingtheletter
andtheabilitytosendtheexactsamelettertomorethanoneperson.
1. Beforeyoubegintheproject,youmaywanttoprintahardcopyofProjectEXL-
1touseasavisualreference.
2. Allowforcorrectwordspacingandpunctuationaroundmergedfields.
3. Readthroughallinstructionspriortocompletingtheproject.
1. UsingMicrosoftWord,openProjectWRD-3Letterheadinyour"Word"folder
under"TheHub"folder.
2. Toavoidoverwritingyouroriginalletterheadfile,savethedocumentasProject
WRD-10ModifiedBlockLetterinyour"Word"folderunder"TheHub"folder.
HINt:
Remember to use "Save As."
3. Chooseaneasy-to-readfont,andkeepthefontsizetoamaximumof10-12
points,unlessotherwisenoted.
4. Besureyourdocument'slinespacingissetupusingsinglespacingwithno
additionallinespacingbetweenparagraphs.
5. Usingthemailmergefeature,setupthemaindocumentindicating"Letters"as
thedocumenttype.
6. Usingthemailmergefeature,selectthefile"ProjectEXL-1BattleoftheBands"
inyour"Excel"folderunder"TheHub"folder.
Note:
This step will connect the main document (the letter) to the data source
document; the data source document does not actually display on the screen.
7. Setaleft-alignedtabat3.25inches.
8. Atapproximately2.5inchesdownfromthetop,hitthetabkey,andkeythe
currentdate.
9. Fourlinesbelowthedate,insertthefollowingmergefieldsfortherecipient's
address:
Note:
Insert the necessary spaces and punctuation between merge fields as
shown below.
«First_Name»«Last_Name»
«Band_Name»
«Street_Address»
«City»,«State»«Zip»
For Evaluation Purposes Only