Sort and filter the data for a mail merge in Word 2016 for Mac

附註:  我們想要以您的語言,用最快的速度為您提供最新的說明內容。 本頁面是經由自動翻譯而成,因此文中可能有文法錯誤或不準確之處。讓這些內容對您有所幫助是我們的目的。希望您能在本頁底部告訴我們這項資訊是否有幫助。 此為 英文文章 出處,以供參考。

In some instances, you may not want to use all the information in your mail merge recipients list. You have the option to select just some of the people in the list, and also sort and filter the data, so you include only what you want in the mail merge.

Sort and filter the mail merge list

  1. 開啟合併列印文件 (如果尚未開啟)。

  2. Click Mailings > Edit Recipients.


    如果 [編輯收件者] 呈現灰色而無法使用,按一下 [選取收件者],並將文件連接到您要使用的郵寄清單。

  3. In Edit List Entries, to add or remove people in the list, click the plus (+) sign to add a person or the minus (-) sign to remove a person from the list.


  4. When you're finished selecting the people you want to have in your list, click OK.


You can sort your list of recipients to group your information in certain ways. For example, if you want to send email only to people who live in specific cities, sort by city, so that all the people in each city are grouped together. That will make it easier to select them when you start the merge.

  1. Click Mailings >Filter Recipients.

  2. Click Sort Records > Sort By, and select the field name you want to sort by.

    按一下 [資料排序] 即可為合併列印的項目排序

    To sort by multiple fields—for example, by state and then by city, click Then By, and then select the additional fields you want to sort by.


  3. When all of the fields are sorted how you want, click OK.

Filter the list to view only the rows you want to include

You can filter the list so that just the people or items you want to include in the merge appear—for example, only people in a specific city or inventory items at a specific price.

  1. Click Mailings >Filter Recipients.


  2. In Filter Records, click the arrow next to the Field box, and then click the column you want to filter by, for example Title or Last_Name.


  3. Click Comparison, and then click the type of comparison you want to make.

    按一下您要設定的 [比較] 選項

  4. In the Compare to box, type the value for the filter. For example, if you select City in the Field list, type the name of the city.

  5. 按一下 [且][或],然後新增其他條件至篩選。例如,如果您想要兩個縣市的結果,請依序按一下 [或][欄位] 清單中的 [縣市]、[等於],然後輸入第二個縣市的名稱。

  6. 按一下 [確定]

Now you’re ready to insert mail merge fields in the document you’re using for email merge or labels. For more information, see Insert mail merge fields.

增進您的 Office 技巧
加入 Office 測試人員



感謝您的意見反應! 我們將協助您與其中一位 Office 支援專員連絡以深入了解您的意見。