Word ??? ???? ????? ?? ??? ???? Excel ????? ????? ?? ??? ?? ????? ???? ????

• ????? ???????? ??? ??? ?????? ?????????? ??? ?? ?? ?? ??? ??? ??? ?? ???? ???????, ???, ?? ????????? ??? ?? ?? ?????? ???????? ?? ????? ??? (???? ?????????????? ?? ??? ?? ???) ?? ?????? ???????? ???? ?? ??? "???? ?????" ?? ???? ???
• ???????????? ???? ??? ???? ??????? - ?????? ?? ???, ???? Microsoft Access 2002 ??????? ????? ?? ??? Excel ????????????? - ?????? ?????? ???????? ??? ???? ???? ?? ??? ?? ?? ???? ??? ?? ??????? ?????????? ???, ??? ?? ??? ???? ?? ?? ???? ???
• ?????? ???????? ?? ??? ???? ?? ?????? ???? ??? ?????? ???????? ??? ??? ?????? ??? ??? ??????????? ??? ?? ?? ???? ??, ????? ?? ??????? ???????? ?? ??? ??????? ???? ?? ???? ????

??? 1: ??? ?? Excel ?? ???? ?????

• ????? ?????? ??? ???????? ????? ?? ??? ????? ??? ??? ???? ?????? ?????? ?? ???, ??????, ???????, ????? ???, ???? ???, ????? ???, Address1 ?? Address2.
• ???????? ????? ??? ????? ???? ?????? ???
• ???????? ?????? ??? ?? ????? ???? ?? ???? ??? ??????? ?????? ???? ?????? ??? ???? ???? ???, ?????? ?? ???, ???????? ?????? ????? ?? ???? ??? ???? ????? ???????????? ?? ???? ??? ????????
• ?????? ?? ??? ????? ????????? ???? ???? ??????

1. ???? Excel ?? ???? ????? ?????, ?? ?? ???? ???? ?? ??? ????? ???? ?? ??? ????? ????? ???? ????? ??? ?????? ?????? ????? ?? ????? ???? ????????? ????:
   
   

   Last Name	First Name	Title	Address	City	Postal Code	Country
   Davolio	Nancy	Sales Representative	1234 Main St. Apt. 2A	Seattle	14222	USA
   Fuller	Andrew	Vice President, Sales	1235 Main St.	Tacoma	14222	USA
   Leverling	Janet	Sales Representative	1235 Elm St.	Kirkland	14222	USA
   Peacock	Margaret	Sales Representative	1236 Main St.	Redmond	14222	USA
   Buchanan	Steven	Sales Manager	1237 Main St	London	SW2 8MR	UK
   Suyama	Michael	Sales Representative	1238 Elm St.	London	EC3 7HR	UK
   King	Robert	Sales Representative	1239 Main St.	London	RK2 9NP	UK
   Callahan	Laura	Inside Sales Coordinator	1230 Elm St.	Seattle	14222	USA
   Dodsworth	Anne	Sales Representative	1231 Elm St.	London	WG2 7LT	UK

   
   
   
2. ???? ?? ??? ?? ???? Excel ?? ???? ????? ?? ????? ???, ?? ??? ??????, ?? ???? ????? ?? ??? ?????

??? 2: ??? ????? ???????? ??? ????

1. Microsoft Office Word 2003 ?? Word ?? ??? ?????? ??????? ??????? ????, ?? ????? ???????? ?? ??????????? ?????????????, ?? ???? ?????? ???? ???????.
   
   Microsoft Office Word 2007 ?? Microsoft Word 2010 ??????? ????, ????? ?????????? ??,??? ???? ??????? ???????????? ???? ??????? ????????, ?? ???? ?????? ?? ??? ??? ???? ???????.
2. ?? ??????????????? ?????? ?? ??? ????????? ????,????.
   
   ?????? ???????? ?? ????? ???????? (???????? ??? ??? ?? ????????? ???? ??? ?? ????????, ?????? ?? ???, ????? ??? ?? ??? ??????? ???? ??? ??????? ?? ???????? ??????? ?? ??? ?? ??? ??) ?? ???? ???
3. ????? ????,????: ??????? ????????.
   
   ???:: ??? ?? ??? ???? ?????? ?? ?????? ??? ?? ???? ???????? ????? ???? ?? ??? ????? ??, ?? ??? ???? ????? ????? ?? ????? ?? ???? ????
4. ?????????? ??? ?? ??? ?? ????::
   • ???? ?? ????? ??? ???? ?????:
     1. ????? ????,???????? ????? ?? ????????? ????.
     2. ????? ????,???? ??????.
     3. ????????? ??????????? ????? ???, ?? ?? ????? ???? ???? ?????? ?? ????, ?? ???? ??? ????? ???? ?????? ?? ??? ????OK.
        
        ??? ?? ??? ???? ?????? ?? ???, ?????? ????? ?? ????? ????, ?? ?? ?????? ?? ????? ?????
   • ???? ?????? ????? ???? ?? ??? ??????? ????:
     1. ????? ????,?????? ???????? ?? ??????? ????.
     2. ??????????? ?? ??????? ????????? ???, ?? ?? ?????, ?? ???? ??? ???????? ?? ??? ?????????.
     3. ??? ?? ???????? ???? ??? ????, ?? ????? ???????? ????????? ????-????? ????, ?? ???? ????????. ??????????????? ????? ???, ?? ?? ?????, ?? ???? ??? ???????? ?? ??????????.
        
        Word ???????? ?? ???????? ????? ??? ????????? ???? ??? ??? ?? ?? ???? ?? ??? ??? ????? ???? ???????? ?? ???? ????? ?? ????? ????, ????? ????????????????? ?? ????????, ?? ???? ??? ???? ???? ???????? ?? ??? ????? ??? ?? ????? ????? ????? ???, ????? ????????????? ???????????? ????? ????, ?? ???? ??????? ??????.
5. ????? ????,????: ?????????????? ?? ??? ????.

??? 3: Excel ??? ???? ????? ????????? ????

1. ?? ??????????????????? ?? ??? ????????? ????,???? ?????? ???? ?? ????? ????.
2. ????? ????,???????.
3. ????????? ????? ?? ??? ????????? ????? ???, ?? ?????? ????? ?? ????? ???? ????? ??? ?? Excel ?????????? ?? ????? ?????
   
   ???????? ??? ??, Word ???? ???? ????? ?????? ????? ?? ???
4. ????? ????,?????.
5. ??? ???? Excel ?????????? ??? ?????? ????? ?? ???? ??? ??????? ??, ?? ?? ??????? ?? ?? ?????, ?? ???? ??? ????? ???? ?????? ??? ?? ??? ???? ?? ??? ??OK. ??? ???? ????? ??? ???????????? ??? ????? ???? ?????? ???? ????????????????? ????? ???, ???? ?? ???? ??? ????? ???? ?? ??? ?????????????? ?? ???? ???????? ?? ???? ????

??? 4: ?????????????? ?? ??? ????

1. ???????? ???? ????????????????? ????? ???, ?? ????? ???? ????? ??? ?? ?????????????? ?? ??? ????? ??? ???? ?? ???, ????? ??? ?? ??? ?????:
   • ?????????????? ?? ????????? ???? ?? ??? ??? ?????? ?? ????? ?????
     
     ?? ???? ???? ?????? ?? ??? ???? ???? ???? ??? Select the check boxes next to the recipients that you want to include, and clear the ones next to the recipients that you want to exclude.
     
     ???:: If you know that you want to include most of the list in your merge, clickSelect Alland then clear particular records. Similarly, if you want to include only a few records in the list, clickClear All, and then select the records that you want.
   • Sort items in the list.
     
     This is useful if you want to see items in alphabetical or numeric order. Click the column heading of the item that you want to sort by. For example, if you want to display the list alphabetically by last name, click theLast Namecolumn heading.
   • Filter items in the list.
     
     This is useful if the list contains records that you know that you do not want to see or include in the merge. After you have filtered the list, you can use the check boxes to include and exclude records as described in the previous section. To filter the list, follow these steps:
     1. Click the arrow next to the column heading of the item by which you want to filter.
     2. Click any of the following:
        • (Blanks)displays all the records in which the corresponding field is blank.
        • (Nonblanks)displays all the records in which the corresponding field contains information.
        • If your data source contains records that share the same information, and there are ten or fewer unique values in the column, you can filter by specific information. For example, if there are multiple addresses that list Australia as the country/region, you can filter on Australia.
   • The Mail Merge Recipients dialog box displays only the designated records. To display all the records again, click(All).
   NOTES:
   • ????? ????? ???? ?? ??????, ?? ??? ???? ????? ??? ?? ??? ?? ??? ?? ????? ????, ?? ???? ???(?????). ??????????? ?????? ??????? ??????? ??????????? ???? ?? ?? ?????? ?? ?????? ??? ???? ?? ??? ??? ???
   • ??? ???? ??? ??????? ????????? ??????? ??, ?? ???? ????? ?? ???? ???????? ???????????? ???? ????????????????? ????? ???? ?????????????? ?? ??? ????? ???? ?? ??? ???
2. : ????? ????OK??? ???? ??????? ???
   
   Word ?? ???? ???? ?? ??? ?? ????????? ???????????? ?? ????? ??????
3. : ????? ????????: ?? ???? ???? ????????? ????.

??? 5: ?? ??????? ?? ???? ???? ????????? ????

???? ????? ???????? ????

1. ????? ???????? ??? ????? ???? ???? ?? ????? ???????? ???? ?? ??? ????? ????
2. ????? ??? ?? ???? ?? ?? ???????? ????:
   • ???, ???, ?? ???? ??????? ?? ??? ???
     1. ????? ????,??? ???.
     2. ???????? ??? ???????? ????????? ????? ???, ??? ???? ?? ???? ?? ????? ???? ????? ??? ?? ?? ?? ?????, ?? ???? ??? ?????? ?? ??? ????OK. ??? ?? ??? ???? ?????? ?? ???, ?????? ????? ?? ????? ????, ?? ?? ?????? ?? ????? ?????
        
        
     3. ??? ?? ??? ???? ?????? ?? ???, ?????? ????? ?? ????? ????, ?? ???? ??? option.If ????? ????????? ??????????? ????? ????? ???? ??, ?? Word ???? ??? ?? ???? ?? ??? ??? ??? ?? ??? ?????? ??????? ?????? ??? ?????? ??? ?? ??? ??? ????? ????(?????? ????), ?? ???? ??? ???? ?? ??? ??? ???? ?? ??? ?????? ????? ?? ??????? ?? ?? ???? ???? ????? ?? ????? ?? ??? ?????
   • ??????? ??????
     1. ????? ????,??????? ??????.
     2. ??????? ?????? ?????? ?? ??? ????, ?? ???????, ??? ?? ??????, ?? ????? ????? ????? ????? ????
     3. ?????? ?????? ?? ???? Word ???? ???????? ???????????? ?? ???, ?????? ?? ???, ?? ???? ????? ??? ??? ????? ?? ????? ??? ???? ???????????? ?? ??? ????, ????? ???? ?? ????? ?? ??? ??? ????? ???? ?? ??? ??? ?? ??? ?????
     4. ????? ????,OK.
     5. ???????? ??????????? ????? ????? ???? ??, ?? Word ???? ??? ?? ???? ?? ??? ??????? ?????? ?? ??? ?????? ??????? ?????? ??? ?????? (?????? ???? ??) ?? ??? ???? ??? ????? ????, ?? ?? ???? ?? ??? ??? ???? ?? ??? ?????? ????? ?? ??????? ?? ?? ???? ???? ????? ?? ????? ?? ??? ?????
   • ???? ????????? ?? ???????
     1. ????? ????,???? ????.
     2. ?????????? ??? ?? ??? ?? ????::
        • ?? ??? ???? ?? ???? ???? ????? ??? ???? ?????? ?? ??? ???????? ??? ?? ??? ????? ??? ????? ?? ??? ?? ???? ????? ?? ??? ??? ?? ???? ????? ????? ?? ?? ??? ???? ??, ?? ??? ??? ????? ' ????? ?????
        • ????? ?? ??????? ??? ?? ????? ?? ???? ?? ????? ?? ??? ???? ?? ??? ????? ??????????? ?????.
     3. ??????????????? ???, ?????? ????? ????? ?????
     4. ????? ????,???????? ?????? ????-????? ????, ?? ???? ?????? ????.
     5. ???????? ??????????? ????? ????? ???? ??, ?? Word ???? ??? ?? ???? ?? ??? ????? ???????? ???? ?? ??? ?????? ??????? ?????? ??? ?????? ??? ?? ??? ??? ????? ????(?????? ????), ?? ???? ??? ???? ?? ??? ??? ???? ?? ??? ?????? ????? ?? ??????? ?? ?? ???? ???? ????? ?? ????? ?? ??? ?????
        
        ???:: ??? ?? ?? ?? ????? ???????? ??????????? ?????????, ?? ??? ??? ??? ????? ???? ?? ??? ???? ??? ???? ??? ????? ???? ?? ?? ???? ????? Word ??? ???? ??? ?? ???????? ??? ????? ?? ?? ??????? ?? ???????? ???? ?? ??? ????? ???? ??????
   • ???????????? ???????
     
     ???????????? ??????? ??????, ???? ???? ?? ???????????? ??????? ?????????, ???? ?? ?? ????? ?????? ???? ??? ?? ??? ???? ?? ??????? ???? ????? ???????????? ??????? ?? ????? ????, ????? ????? ?? ???? ????:
     1. ????? ????,???????????? ???????.
        
        ??? ???? ???????????? ??????? ????????? ??????? ???? ??, ?? Word ?? ??????? ???? ?? ??? ????? ???? ?? ?? ????? Microsoft ??? ???? ?? ?????? ???? ?? ??? ???????? ???? ??:
        Microsoft Office ???

        (http://office.microsoft.com/en-us/marketplace/)
     2. ????????? ?? ????????? ?? ?????? ??????? ???????? ?????
   • ???????????? ??????? ??????, ???? ???? ?? ???????????? ??????? ?????????, ???? ?? ?? ????? ?????? ???? ??? ?? ??? ???? ?? ??????? ???? ?????
     
     ?? ??? ???? ?? ?????? ?? ?????? POSTNET ?????? ?? ?????? ???? ?? ?? ?? ??? ???? ?????? ??? ??? ??? ??? ?? ????? ????, ????? ????? ?? ???? ????:
     1. ????? ????,?????? ??? ???.
     2. ??????????? ??? ??? ???????? ????????? ????? ???, ??????? ??? ????? ?? ??? ?????
        
        ???::?????? ??? ????????? ????? ???? ??, ???? ??? ???? ?? ?? Word ?? ??. ??. ???? ??????? ?? ????? ?? ??? ????
     3. ????? ?? ??????? ?? ?? b ?? ??? ?????? ?? ???? ?? ???????? ???? ????? ????
        
        ???:
        • Word 2003 ?? Word ?? ????? ????????? ???, ?? ???? ????? ???? ???? ???? ???? ?? ???? ("") ?? ?????? ?? ????? ?? ???????? ???????????? command???????? ???????? ??..
          
          Word 2007 ?? Word 2010 ???, ?? ???? ????? ???? ???? ???? ???? ?? ???? ("") ?? ?????? ?? ????? ?? ???????? ????????????? command???????? ???????????? ??????? ?? ????? ????..
        • ??? ???? ????? ????? ???? {???? ????? ???}, braces ?? ???? ??? Word ?? ????????? ????? ????? ????? ?? ?????? ?? ????? ??? ?? ????, ??? ?? ???? ???? ?????? ????????? ????, ?????? ??? ?? ????-????? ????, ?? ???? ??? ???? ????? ??? ????? ???????? ???? ????????? ??? ?? ???? ??????????? ???? ???
   ???:Word 2003 ?? Word ?? ????? ????????? ???, ?? ?? ????? ?? ???? ??? ???? ????? ????? ???? ????? ???????? ????, ???? ??? ???? ????? ???????? ?? ??? ????? ???? ?? ???, ?? ??? ??? ???? ?? ????? ?? ???? ??? ???? ????? ????? ?? ????????? ???? ?? ??? ????? ???? ?? ??????? ?? ??????????? ?????????????, ?? ???? ?????? ???? ????? ????? ??????. ??? ???? ????? ????? ?? ??? ???? ??????? ????? ??? ??? ????? ???? ???????? ???? ???? ??? For example, you can use the Insert Word Field drop-down menu on the Mail Merge toolbar to insert Word fields for controlling the merge process (for example, an IF field that inserts text only if a particular merge field has a specified value). Or, you can clickCheck For Errorsto have Word run the mail merge and report any errors contained in the main document.

Change the Format of the Merged Data

1. In the main document, select the field containing the information that you want to format, including the merge field characters ("" "") that enclose it.
2. In Word 2003 and in earlier versions or Word, click?????on theFormatmenu, and then select the options that you want.
   
   In Word 2007, on the????? ???????? ??,???????????????group to open the?????dialog box, and then select the options that you want.

Format by Using Field Codes

1. To display the number "34987.89" as "$34,987.89," add the Numeric Picture switch (\#).
2. To print client names in uppercase letters, add the Format switch (\*).
3. To make sure that the merged information has the same font and point size that you apply to the merge field, add the \* Charformat switch.

Step 6: Save the Document

1. Word 2003 ?? Word ?? ????? ????????? ???, ????? ?????? ??? ??? ??????????? ???????????? ??..
   
   ??? 2007 ????, ????? ????Microsoft Office ????? ????-????? ????, ?? ???? ????? ??? ??? ??????.
   
   Word 2010, ??? ????? ?????????? ????-????? ????, ?? ???? ????? ??? ??? ??????.
   
2. ???????? ?? ???, ?? ???? ??? ????? ??????????.
3. ????? ????,????: ???? ?????? ?? ??????????? ????.

??? 7: ???? ?? ??????????? ???? ?? ???????????? ???? Fine-Tune

Vice President, Sales Andrew Fuller     Sales Representative Anne Dodsworth
1235 Main St                            1231 Elm St.
Tacoma                                  London
	
	
Sales Representative Janet Leverling     Inside Sales Coordinator Laura Callahan
1235 Elm St.                             1230 Elm St.
Kirkland                                 Seattle
				

• ???? ??? ?????? ?? ??????????? ?? ??? ???? ?? ???? ??? ????? ?? ????? ?????
  
  ???????? ?????? ????? ?? ???? ???? ??? ??????????? ???? ??? ???
• ?? ?????? ?????, ?? ??? ??????? ???? ?? ??????????? ????, ????? ???????? ???????????? ??????, ?? ???? ??? ??? ??? ?????? ?? ???? ????????????? ??????????? ????? ?? ??????? ?? ??? ?? ..

1. ????? ????,???????????? ???? ??????? ????, ?? ???? ??? ??? ???? ???????? ??????? ???? ????????????????? ????? ?? ??????? ?? ??? ?? ..
2. ????? ????,????: ????? ????.

??? 8: ???? ???? ????

???-??? ???? ?? ????????? ?????

1. ????? ????,???-??? ???? ??????? ????.
2. ??????? ???????? ??? ???? ????????? ????? ???, ?????? ???? ???? ????? ??? ?? ?? ??? ?????
3. ????? ????,OK.
   
   Word ????? ?? ?? ??? ??? ???? ??? ?? ????????? ????? ??? ???? ????? ???????? ?? ???? ?????, ?? ?? ?? ???? ??? ?? ????? ?? ??? ?? ??? ???????? ???? ?? ??? ??? ???? ????? ????? ????
4. ??????? ???? ?? ??? ??????? ??????? ????, ?? ???? ???????? ???? ????? ????
5. ?????? ?? ?? ??? ?? ???? ??? ?? ?????? ???????? ???? ???????? ?? ???????

???? ?? ????? ??????? ????

• ??? ?? ?????? ?? ?????????? ???? ?? ???? ??? ?? ???????? ?????? ??:
  1. Word 2003 ?? Word ?? ????? ????????? ???, ????? ??????????? ????????? ???????????? ??..
     
     ??? 2007 ????, ????? ????Microsoft Office ????? ????? ????,??????? ?????? ????-????? ????, ?? ???? ?????????? ????.
     
     Word 2010, ??? ????? ????????????? ????,??????? ?????? ????-????? ????, ?? ???? ?????????? ????,
     
  2. ?????? ???????? ?? ??? ?????
• ??? ?? ??? ???? ??????? ?? ??????? ???? ????? ???:
  1. ??? ???? ??????? (?? ??? 6 ??????? ???? ????), ????? ??????????? ????.
  2. ???????????? ??? ???? ????????? ????? ???, ????? ??? ?? ??? ?? ????? ????, ?? ???? ??? ????? ????OK:
     • ??? ??????????? ?? ??????? ???? ?? ??? ????? ???????.
     • ???????? ????? ??? ????? ???????? ?? ??????? ???? ?? ??? ????? ??????????? ??????.
     • ???????? ?? ?? ?????? ?? ??????? ???? ?? ??? ????? ??????, ?? ???? ??? ??? ?????? ??????? ???????, ?????? ?? ???????? ????
  3. ???????????? ????????? ????? ???, ?????? ???????? ?? ??? ?????

???? ?? ????? ?? ??? ??? ????? ?? ??? ??????

1. ????? ????,???-??? ???? ??????? ????.
2. ???????? ??? ???????? ??? ???? ????????? ????? ???, ????? ??? ?? ??? ?? ????? ????, ?? ???? ??? ????? ????OK:
   • ??? ?????????? ?? ???? ???? ?? ??? ????? ???????.
   • ???? ???????? ?? ?? ???????? ????? ??? ????? ?? ???? ???? ?? ??? ????? ??????????? ??????.
   • ???????? ?? ?? ?????? ?? ???? ???? ?? ??? ????? ??????, ?? ???? ??? ??? ?????? ??????? ???????, ?????? ?? ???????? ????
3. Word ?? ??? ?? ??? ???????? ???-??? ???? ??? ????? ??? ?? ?? ???? ???? ???, ??? ??? ????? ?? ??? ???????? ??? ??? ??????? ???????? ???? ?? ????

??????

????? ?? ???? ???? | ??????????? ???