排序和筛选的数据在 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 支持专员。

×