跳到主要內容

如何將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


尖端: 在這個視頻裡, 庫工具 選項卡添加者 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