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
   96   97   98   99   100   101   102   103   104   105   106