Note: The other languages of the website are Google-translated. Back to English
Mewngofnodi  \/ 
x
or
x
Cofrestru  \/ 
x

or

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 rheol gallwn allforio / cadw neges e-bost fel ffeil testun gyda'r nodwedd Save As yn Outlook. Ond, ar gyfer arbed batsh / allforio sawl e-bost i ffeiliau testun unigol, mae'n rhaid i chi drin pob neges â llaw fesul un. Yn cymryd llawer o amser! Tedious! 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! Cliciwch am dreial 60 diwrnod am ddim heb gyfyngiad!
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!


Kutools for Outlook - Yn Dod â 100 o Nodweddion Uwch i'w Rhagweld, a Gwneud Gwaith yn Haws Osgach!

  • Auto CC / BCC yn ôl rheolau wrth anfon e-bost; Auto Ymlaen E-byst Lluosog yn ôl arfer; Ymateb Auto heb weinydd cyfnewid, a nodweddion mwy awtomatig ...
  • Rhybudd BCC - dangoswch neges pan geisiwch ateb popeth os yw'ch cyfeiriad post yn rhestr BCC; Atgoffwch Wrth Ymlyniadau ar Goll, a mwy o nodweddion atgoffa ...
  • Ymateb (Pawb) Gyda'r Holl Atodiadau yn y sgwrs bost; Ateb Llawer o E-byst mewn eiliadau; Auto Ychwanegu Cyfarchiad wrth ateb; Ychwanegu Dyddiad i'r pwnc ...
  • Offer Ymlyniad: Rheoli Pob Atodiad ym mhob Post, Datgysylltiad Auto, Cywasgu Pawb, Ail-enwi Pawb, Arbed Pawb ... Adroddiad Cyflym, Cyfrif Postiau Dethol...
  • E-byst Sothach Pwerus yn ôl arfer; Tynnwch y Post a Chysylltiadau Dyblyg... Yn eich galluogi i wneud yn ddoethach, yn gyflymach ac yn well yn Outlook.
tab kutools rhagweld kutools tab 1180x121
kutools rhagweld rhagolygon kutools ynghyd â thab 1180x121
 
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    travis · 1 years ago
    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!
  • To post as a guest, your comment is unpublished.
    Misha · 3 years ago
    Thanks so much. Great instructions and it made it easy. Appreciate the help.
  • To post as a guest, your comment is unpublished.
    Susan · 4 years ago
    Awesome! The instructions on importing grouped contacts worked perfectly! Thank you!
  • To post as a guest, your comment is unpublished.
    Uma · 4 years ago
    Worked beautifully. Thanks a lot!
  • To post as a guest, your comment is unpublished.
    Uma · 4 years ago
    Worked perfectly. I have been wanting to do this and these instructions helped me each step of the way.

    Thanks again.
  • To post as a guest, your comment is unpublished.
    Keara · 4 years ago
    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?
    • To post as a guest, your comment is unpublished.
      Christy Nicholas · 4 years ago
      Same here. I get the name of the group and the admins and notes, but NO contacts listed at all. It's highly frustrating.
    • To post as a guest, your comment is unpublished.
      Bernard · 4 years ago
      Same thing happens to me. I get the contact group. but the contacts in the group are not displayed.
    • To post as a guest, your comment is unpublished.
      Bernard · 4 years ago
      [quote name="Keara"]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?[/quote]
      That is exactly what happens when I follow these steps. I get the contact group name, but the members are not listed.
  • To post as a guest, your comment is unpublished.
    Emma · 5 years ago
    This is was so easy to follow and worked perfectly, thanks
  • To post as a guest, your comment is unpublished.
    Joyce · 5 years ago
    Very Helpful indeed!
  • To post as a guest, your comment is unpublished.
    Margaret Murray · 5 years ago
    Thank you very helpful