Page 101 - FUNDAMENTALS OF COMPUTER
P. 101
NPP MS-Word & Excel 101
NPP
Fig. 2.19: Selecting starting document Fig. 2.20: Selecting list of recipient
5. We are using an excel sheet which is 5. h_ ¶hm± EH$ EŠgoc erQ> H$m Cn`moJ H$aVo h¢,
assumed to contain names and {Og_| CZ ì`{ŠV`m| Ho$ Zm_ Ed§ nVo em{_c h¢,
addresses of the person to whom a
common letter is to be sent. So, we {OÝh| g_mZ àH$ma Ho$ nÌ ^oOo OmZo h¢& Bg{cE
choose existing list. To locate that list h_ dV©_mZ {cñQ> H$m M`Z H$aVo h¢& {cñQ> H$s
we will have to click on Browse button. cmoHo$eZ hoVw ~«mCg ~Q>Z na {ŠcH$ H$aZm hmoJm&
After selecting the desired sheet we Cn`wŠV erQ> Ho$ M`Z Ho$ níMmV² AmoHo$ na {ŠcH$
click on OK. A dialog box containing H$a|& EH$ S>m`cm°J ~m°Šg {Og_| g^r [aH$m°S>²©g
all the records will appear. Here we CnpñWV h¡, {XIoJm& `hm§ h_ coQ>g© Ho$ OZaoeZ
can choose the records to be used for
generation of letters. If we don't want hoVw Cn`moJ _| AmZo dmco [aH$m°S²>©g H$m M`Z H$a|Jo&
to use some records we need to `{X h_| Hw$N> [aH$m°S>²©g H$m Cn`moJ Zht H$aZm h¡,
uncheck them. h_| Cgo AZMoH$ H$aZm hmoJm&
6. When we proceed further, a Box in the 6. O~ h_ AmJo ~‹T>|Jo; {MÌ-2.21 _| Xem©E AZwgma
right with the starting document coâQ> _| ñQ>m{Q>ªJ S>m°Š`y_|Q> AmonZ hmoZo Ho$ gmW
opened in the left appears as shown in
fig-2.21. Address Block and Greeting hr amBQ> _| EH$ ~m°Šg IwcoJm& ES´>og ãcm°H$ VWm
Line fields are already inserted into J«rqQ>J cmBZ nhco go hr S>m°Š`y_|Q> _| BÝgQ>}S>
the document. Address Block indicates h¡& ES´>og ãcm°H$ _| coQ>a àmßVH$Vm© Ho$ Zm_ _m¡OyX