Ntshuam Cov Neeg Los Ntawm Excel lossis CSV Cov Ntaub Ntawv rau hauv Outlook

Cov txheej txheem:

Ntshuam Cov Neeg Los Ntawm Excel lossis CSV Cov Ntaub Ntawv rau hauv Outlook
Ntshuam Cov Neeg Los Ntawm Excel lossis CSV Cov Ntaub Ntawv rau hauv Outlook
Anonim

Yuav Paub

  • Desktop: Mus rau File > Open & Export > Import/Export qhib tus Import/Export Wizard.
  • Cia li xaiv Ntshuam los ntawm lwm qhov kev pab cuam lossis cov ntaub ntawv > Comma Separated Values. Xaiv cov ntaub ntawv CSV thiab ua raws cov kauj ruam ntawm qhov screen.
  • Outlook.com: Qhib Applications Launcher > People > Manage >Import contacts > Browse . Xaiv cov ntaub ntawv CSV thiab xaiv Open.

Cov ntaub ntawv khaws cia hauv cov ntaub ntawv lossis cov ntawv nthuav tawm tuaj yeem nkag tau yooj yim rau hauv Outlook. Hauv phau ntawv qhia no, peb qhia koj yuav ua li cas import cov neeg sib cuag los ntawm CSV cov ntaub ntawv siv Outlook 2019, 2016, 2013, 2010, Outlook rau Microsoft 365, thiab Outlook.com.

Ntshuam hu los ntawm CSV cov ntaub ntawv rau hauv Outlook

Nyob hauv database lossis spreadsheet program, xa cov ntaub ntawv hu mus rau CSV (comma cais qhov tseem ceeb) cov ntaub ntawv. Nco ntsoov tias cov kab ntawv muaj cov ntsiab lus tseem ceeb, txawm tias lawv tsis tas yuav tsum sib haum rau cov teb uas siv hauv phau ntawv chaw nyob Outlook. Koj muaj peev xwm manually daim ntawv qhia txhua kab rau teb thaum lub sij hawm ntshuam txheej txheem.

Cov screenshots hauv qab no yog rau Outlook 2016. Cov ntxaij vab tshaus hauv lwm cov qauv ntawm Outlook yuav txawv me ntsis, tab sis cov kauj ruam yog tib yam. Txhua qhov kev hloov pauv rau cov ntawv qub yuav raug sau tseg.

  1. Go to File.
  2. Click Open & Export. Hauv Outlook 2010, ces nyem Open.

    Image
    Image
  3. Click Import/Export. Hauv Outlook 2010, nyem Import.
  4. In the Import and Export Wizard, xaiv Ntshuam los ntawm lwm qhov kev pab cuam lossis cov ntaub ntawv, tom qab ntawd nyem Next.

    Image
    Image
  5. Xaiv Cov nqi sib cais, ces nyem Next.

    Image
    Image
  6. Click Browse, tom qab ntawd nrhiav cov ntaub ntawv CSV uas muaj cov neeg koj xav tau import.

    Yog tias koj siv Gmail, xa koj tus Gmail hu rau hauv CSV cov ntaub ntawv, tom qab ntawd import koj cov neeg Gmail rau hauv Outlook.

    Image
    Image
  7. Xaiv ib qho ntawm cov hauv qab no:

    • Tsis txhob ntshuam cov khoom qub.
    • Hloov duplicates nrog cov khoom imported. Yog tias cov ntaub ntawv hauv CSV cov ntaub ntawv tsis ntev los no lossis ntau dua, qhov no yuav yog qhov kev xaiv zoo tshaj plaws.
    • Cia duplicates tsim. Yog tias qhov sib npaug raug tsim, koj tuaj yeem tshawb nrhiav thiab tshem tawm lawv txhua lub sijhawm siv cov khoom siv tshem tawm duplicate, piv txwv li.
  8. Click Next.

  9. Xaiv Outlook nplaub tshev uas koj xav import cov neeg sib cuag. Qhov no tej zaum yuav yog koj li Contacts folder, los yog nws tuaj yeem yog Contacts folder hauv ib qho ntawm koj lwm cov folders. Koj tseem tuaj yeem tsim ib lub nplaub tshev Outlook rau cov khoom tuaj txawv teb chaws.

    Image
    Image
  10. Click Next.
  11. Click Daim Ntawv Qhia Kev Cai.

    Image
    Image
  12. Daim ntawv qhia txhua kab los ntawm CSV cov ntaub ntawv mus rau qhov xav tau Outlook chaw nyob phau ntawv teb. Outlook cia li qhia qee qhov chaw; hloov cov no yog tias lawv tsis tau kos npe kom raug.

    To map a field, drag the Value rau qhov xav tau Field.

    Image
    Image
  13. Click OK, thiab tom qab ntawd nyem Finish pib txheej txheem ntshuam.

Ntshuam hu rau ntawm Outlook.com

Koj tuaj yeem xa koj cov ntaub ntawv CSV rau Outlook.com thiab. Cov txheej txheem txawv me ntsis ntawm cov software versions.

  1. Qhib lub Applications Launcher thiab nyem People.

    Image
    Image
  2. Click Manage > Ntshuam hu.

    Image
    Image
  3. Click Browse.

    Image
    Image
  4. Xaiv cov ntaub ntawv CSV, tom qab ntawd nyem Open.

    Image
    Image
  5. In the Import contacts dialog box, nyem Import.

    Image
    Image
  6. Koj cov neeg raug xa tawm thiab xa mus rau koj tus email Outlook.com.
  7. Thaum cov txheej txheem tiav lawm, nyem Kaw. Koj yuav pom cov neeg tshiab hauv koj phau ntawv chaw nyob Outlook.

    Image
    Image

Pom zoo: