Skip i'r prif gynnwys

Sut i allforio grwpiau cyswllt Outlook i Excel?

Efallai y bydd yn eithaf hawdd allforio ffolder cyswllt cyfan o Microsoft Outlook fel ffeil .csv neu lyfr gwaith Excel. Fodd bynnag, efallai y bydd rhai defnyddwyr ond eisiau allforio grŵp cyswllt penodol o Outlook, sut i wneud hynny? Yn yr erthygl hon, byddaf yn dangos i chi'r camau ynghylch allforio grwpiau cyswllt Outlook i mewn i Excel.

Allforio grwpiau cyswllt Outlook i Excel


Allforio grwpiau cyswllt Outlook i Excel

I allforio grŵp cyswllt penodol o Outlook i Excel, gallwch wneud fel a ganlyn:

1. Newid i'r golwg Cyswllt, dewiswch y grŵp cyswllt y byddwch chi'n ei allforio, ac yna cliciwch ar y Ffeil > Save As.

2. Yn y blwch deialog Save As,
(1) Dewiswch y ffolder y byddwch chi'n cadw'r grŵp cyswllt hwn ynddo;
(2) Rhowch enw ar gyfer y grŵp cyswllt a allforir yn y enw ffeil blwch;
(3) Cliciwch y Cadw fel math blwch, a dewiswch y Testun yn Unig o'r gwymplen;
(4) Cliciwch y Save botwm.

3. Creu llyfr gwaith gwag, ac yna cliciwch ar y Ffeil (neu Botwm swyddfa)> agored or Ffeil > agored > cyfrifiadur > Pori.
 

4. Yn y blwch deialog popping up Open,
(1) Agorwch y ffolder y gwnaethoch chi arbed y grŵp cyswllt a allforiwyd ynddo nawr;
(2) Cliciwch yr ail flwch y tu ôl i'r enw ffeil, Ac yna dewiswch Pob Ffeil (neu Ffeiliau Testun) o'r gwymplen;
(3) Cliciwch i ddewis ffeil testun grŵp cyswllt wedi'i allforio, ac yna cliciwch ar y agored botwm.

5. Yn y blwch deialog Dewin Mewnforio Testun, gwnewch yn siŵr bod y Wedi'i ddosbarthu mae'r opsiwn yn cael ei wirio, ac yna cliciwch ar y Gorffen botwm.

Yna mae'r grŵp cyswllt yn cael ei allforio i'r Daflen Waith yn llwyddiannus gyda gwybodaeth enw'r grŵp ac aelodau.

6. Cadw a chau'r llyfr gwaith.

Un clic i arbed / allforio sawl e-bost i ffeiliau testun / PDF / HTML / CSV mewn swmp yn Outlook

Fel arfer gallwn allforio/arbed neges e-bost fel ffeil testun gyda'r nodwedd Cadw Fel yn Outlook. Ond, ar gyfer swp-arbed/allforio e-byst lluosog i ffeiliau testun unigol, mae'n rhaid i chi drin pob neges un wrth un. Yn cymryd llawer o amser! Diflas! Nawr, Kutools ar gyfer Outlook's Arbed Swp gall nodwedd eich helpu i arbed nifer o negeseuon e-bost yn gyflym i ffeiliau testun unigol, ffeiliau PDF, ffeiliau HTML, ac ati gyda dim ond un clic!


swp ad ac eithrio fel 9.50

Demo: Allforio grwpiau cyswllt Outlook i Excel


Tip: Yn y Fideo hwn, Kutools tab yn cael ei ychwanegu gan Kutools ar gyfer Rhagolwg. Os oes ei angen arnoch, cliciwch yma i gael treial am ddim 60 diwrnod heb gyfyngiad!


Offer Cynhyrchiant Swyddfa Gorau

Kutools ar gyfer Rhagolwg - Dros 100 o Nodweddion Pwerus i Werthu Eich Outlook

🤖 Cynorthwy-ydd Post AI: E-byst pro ar unwaith gyda hud AI - un clic i atebion athrylith, tôn berffaith, meistrolaeth amlieithog. Trawsnewid e-bostio yn ddiymdrech! ...

📧 E-bostio Automation: Allan o'r Swyddfa (Ar gael ar gyfer POP ac IMAP)  /  Amserlen Anfon E-byst  /  Auto CC/BCC gan Reolau Wrth Anfon E-bost  /  Awto Ymlaen (Rheolau Uwch)   /  Auto Ychwanegu Cyfarchiad   /  Rhannwch E-byst Aml-Dderbynnydd yn Negeseuon Unigol yn Awtomatig ...

📨 Rheoli E-bost: Dwyn i gof E-byst yn Hawdd  /  Rhwystro E-byst Sgam gan Bynciau ac Eraill  /  Dileu E-byst Dyblyg  /  Chwilio Manwl  /  Cydgrynhoi Ffolderi ...

📁 Ymlyniadau ProArbed Swp  /  Swp Datgysylltu  /  Cywasgu Swp  /  Auto Achub   /  Datgysylltiad Auto  /  Cywasgiad Auto ...

🌟 Rhyngwyneb Hud: 😊Mwy o Emojis Pretty a Cŵl   /  Rhowch hwb i'ch Cynhyrchiant Outlook gyda Golygfeydd Tabbed  /  Lleihau Outlook Yn lle Cau ...

???? Rhyfeddodau un clic: Ateb Pawb ag Ymlyniadau Dod i Mewn  /   E-byst Gwrth-Gwe-rwydo  /  🕘Dangos Parth Amser yr Anfonwr ...

👩🏼‍🤝‍👩🏻 Cysylltiadau a Chalendr: Swp Ychwanegu Cysylltiadau O E-byst Dethol  /  Rhannwch Grŵp Cyswllt i Grwpiau Unigol  /  Dileu Atgoffa Pen-blwydd ...

Dros Nodweddion 100 Aros Eich Archwiliad! Cliciwch Yma i Ddarganfod Mwy.

 

 

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