跳到主要内容

如何将Outlook联系人组导出到Excel?

从Microsoft Outlook中将整个联系人文件夹导出为.csv文件或Excel工作簿可能非常容易。 但是,某些用户可能只想从Outlook中导出某个联系人组,如何完成它? 在本文中,我将向您展示有关将Outlook联系人组导出到Excel中的步骤。

将Outlook联系人组导出到Excel


将Outlook联系人组导出到Excel

要将某个联系人组从Outlook导出到Excel,可以执行以下操作:

1。 切换到“联系人”视图,选择要导出的联系人组,然后单击 文件 > 另存为.

2。 在另存为对话框中,
(1)选择要将此联系人组保存到的文件夹;
(2)为导出的联系人组输入名称。 文件名 框;
(3)点击 保存类型 框,然后选择 纯文本 从下拉列表中;
(4)点击 保存 按钮。

3。 创建一个空白工作簿,然后单击 文件 (或 办公按钮)> 可选 or 文件 > 可选 > 电脑 > 浏览.
 

4。 在弹出的打开对话框中,
(1)打开刚才保存导出的联系人组的文件夹;
(2)点击 文件名,然后选择 所有文件 (或 文本文件)从下拉列表中;
(3)单击以选中导出的联系人组的文本文件,然后单击 可选 按钮。

5。 在弹出的“文本导入向导”对话框中,确保 分隔 选项被选中,然后单击 完成 按钮。

然后,将联系人组连同组名和成员信息一起成功导出到工作表中。

6。 保存并关闭工作簿。

一键式将多封电子邮件保存/导出到Outlook中的文本/ PDF / HTML / CSV文件中

通常我们可以使用 Outlook 中的“另存为”功能将电子邮件导出/另存为文本文件。但是,要将多封电子邮件批量保存/导出到单个文本文件,您必须逐条手动处理每封邮件。耗时!乏味!现在,Kutools for Outlook 批量保存 功能可以帮助您快速地将多个电子邮件消息保存到单个文本文件,PDF文件,HTML文件等中!


广告批次另存为9.50

演示:将Outlook联系人组导出到Excel


Tips:: 在这个视频里, 库工具 选项卡添加者 Kutools for Outlook。 如果需要,请单击 了解更多 免费试用60天!


最佳办公生产力工具

Kutools for Outlook - 超过 100 种强大功能可增强您的 Outlook

🤖 人工智能邮件助手: 具有人工智能魔力的即时专业电子邮件——一键天才回复、完美语气、多语言掌握。轻松改变电子邮件! ...

📧 电子邮件自动化: 外出(适用于 POP 和 IMAP)  /  安排发送电子邮件  /  发送电子邮件时按规则自动抄送/密件抄送  /  自动转发(高级规则)   /  自动添加问候语   /  自动将多收件人电子邮件拆分为单独的消息 ...

📨 电子邮件管理: 轻松回忆电子邮件  /  按主题和其他人阻止诈骗电子邮件  /  删除重复的电子邮件  /  高级搜索  /  合并文件夹 ...

📁 附件专业版批量保存  /  批量分离  /  批量压缩  /  自动保存   /  自动分离  /  自动压缩 ...

🌟 界面魔法: 😊更多又漂亮又酷的表情符号   /  使用选项卡式视图提高 Outlook 工作效率  /  最小化 Outlook 而不是关闭 ...

👍 一键奇迹: 使用传入附件回复全部  /   反网络钓鱼电子邮件  /  🕘显示发件人的时区 ...

👩🏼‍🤝‍👩🏻 通讯录和日历: 从选定的电子邮件中批量添加联系人  /  将联系人组拆分为各个组  /  删除生日提醒 ...

超过 100特点 等待您的探索! 单击此处了解更多。

了解更多       免费下载      购买
 

 

Comments (12)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
man.... I looked everywhere and this was it! One thing I will note, I had a group contact that couldn't be expanded. To do this, I expanded the list from my email, copied the recipients and then created a new contact group and pasted the names from my email in the members section at the bottom in the new group window. This populated the names and emails in two separate columns that allowed me to save into the text file and import into excel. Thanks again!
This comment was minimized by the moderator on the site
Thanks so much. Great instructions and it made it easy. Appreciate the help.
This comment was minimized by the moderator on the site
Awesome! The instructions on importing grouped contacts worked perfectly! Thank you!
This comment was minimized by the moderator on the site
Worked beautifully. Thanks a lot!
This comment was minimized by the moderator on the site
Worked perfectly. I have been wanting to do this and these instructions helped me each step of the way. Thanks again.
This comment was minimized by the moderator on the site
Thank you for these instructions. They were very helpful, but when I follow these steps I can get it to work, but the actual group member names are not listed. Only the Contact Group Name: and then under Members: it repeats the Contact Group name (and does not list the members. Any idea what I'm doing wrong and how to fix the problem?
This comment was minimized by the moderator on the site
Same here. I get the name of the group and the admins and notes, but NO contacts listed at all. It's highly frustrating.
This comment was minimized by the moderator on the site
Same thing happens to me. I get the contact group. but the contacts in the group are not displayed.
This comment was minimized by the moderator on the site
[quote]Thank you for these instructions. They were very helpful, but when I follow these steps I can get it to work, but the actual group member names are not listed. Only the Contact Group Name: and then under Members: it repeats the Contact Group name (and does not list the members. Any idea what I'm doing wrong and how to fix the problem?By Keara[/quote] That is exactly what happens when I follow these steps. I get the contact group name, but the members are not listed.
This comment was minimized by the moderator on the site
This is was so easy to follow and worked perfectly, thanks
This comment was minimized by the moderator on the site
Very Helpful indeed!
This comment was minimized by the moderator on the site
Thank you very helpful
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations