Ungangenisa kanjani Oxhumene nabo kusuka ku-Excel noma ifayela le-CSV ku-Outlook

Ifolda yoxhumana nabo ku- Outlook yindawo egcina bonke oxhumana nabo? Kuhle.

Uma kungenjalo, amathuba okuba uthole kalula labo abangabikho abangani, osebenza nabo kanye nabajwayele lapho (futhi uwasebenzise ukudala uhlu lokusabalalisa , isibonelo).

Idatha yokuthintana egcinwe ku-database noma ispredishithi ngokuvamile ingangeniswa ku-Outlook ngaphandle kokuhlukunyezwa okuningi. Esikhathini sedatha noma ispredishithi, thumela idatha kwifayela le-CSV (ama-value ahlukaniswe ngama-comma) ukuqinisekisa ukuthi amakholomu anezinhlokweni ezinengqondo. Akudingeki ukuba zihambelane nemasimu asetshenziswe ebhukwini lekheli le-Outlook. Ungahlela amakholomu emasimini ngokuguquguqukayo ngesikhathi senqubo yokungenisa.

Ngenisa Oxhumana nabo kusuka ku-Excel noma ifayela le-CSV ku-Outlook

Ukungenisa idatha yebhuku lekheli kusukela kufayela le-CSV noma kusuka ku-Excel kuya koxhumana nabo be-Outlook:

  1. Chofoza Ifayela ku-Outlook.
  2. Iya kusigaba sokuvula nokuthekelisa .
  3. Chofoza ukungenisa / ukuthumela ngaphandle kokungenisa / ukuthumela .
  4. Qinisekisa ukungenisa kusuka kwesinye isistimu noma ifayela likhethiwe ngaphansi Khetha isenzo sokwenza:.
  5. Chofoza Okulandelayo> .
  6. Qinisekisa ukuthi ama- Comma Ahlukanisiwe Amanani akhethiwe ngaphansi kweKhetha uhlobo lwefayili ukungenisa kusuka:.
  7. Chofoza Okulandelayo> .
  8. Sebenzisa inkinobho ye- Browse ... , bese ukhetha ifayela elifisa le-CSV.
  9. Ngokujwayelekile, qiniseka Ungangenisi izinto eziphindwe kabili noma Faka okuphindwe kabili ngezinto ezithengisiwe ezikhethiwe ngaphansi kwezinketho .
    • Uma ukhetha Vumela ama-duplicates ukuba adalwe , ungakwazi ukusesha nokuqeda izinto eziphindaphindiwe kamuva (usebenzisa isipiliyoni sokususa okuphindiwe, isibonelo).
    • Khetha Ukubeka okuphindaphindiwe ngezinto ezithengisiwe uma idatha efayeleni le-CSV yamuva noma, mhlawumbe, iphelele ngokwengeziwe; kungenjalo, ukuba ne-Outlook kudale iziphindaphinda kungase kube kuhle.
  10. Chofoza Okulandelayo> .
  11. Khetha ifolda ye-Outlook ofuna ukungenisa oxhumana nabo; lokhu kuzoba ifolda yakho yoxhumana nabo .
    • Ungakhetha ifolda yoxhumana nabo kunoma yiliphi ifayela le-PST, yebo, noma elinye elidalwe izinto ezingenisiwe.
  1. Chofoza Okulandelayo> .
  2. Manje chofoza iMephu Custom Fields ....
  3. Qinisekisa ukuthi wonke amakholomu avela kufayela le-CSV ahlelwe emasimini encwadi yekheli le-Outlook oyifunayo.
    • Ukuze udwebe insimu, donsela isihloko sekholomu (ngaphansi kokusuka ku:) kuya enkundleni oyifunayo (ngaphansi kokuthi :) .
  4. Chofoza OK .
  5. Manje chofoza u- Finish .

Ngenisa Oxhumene nabo kusuka ku-Excel noma ifayela le-CSV ku-Outlook 2007

Ukungenisa oxhumana nabo kusuka kufayela le-CSV ku-Outlook:

  1. Khetha Ifayela | Ngenisa futhi uthumele ... kusukela kwimenyu ku-Outlook.
  2. Qinisekisa ukungenisa kusuka kwenye uhlelo noma ifayela ligqanyisiwe.
  3. Chofoza Okulandelayo> .
  4. Manje qiniseka ukuthi ama- Comma Ahlukanisiwe Amanani (Windows) akhethiwe.
  5. Chofoza Okulandelayo> .
  6. Sebenzisa inkinobho yokudlulisa amehlo ... bese ukhetha ifayela elifunayo.
  7. Ngokujwayelekile, khetha Ungangenisi izinto eziphindwe kabili .
  8. Chofoza Okulandelayo> .
  9. Khetha ifolda ye-Outlook ofuna ukungenisa oxhumana nabo. Lokhu kuzoba ifolda yakho yoxhumana nabo .
  10. Chofoza Okulandelayo> .
  11. Chofoza imephu yamakhadi okwezifiso ...
  12. Qinisekisa ukuthi wonke amakholomu avela kufayela le-CSV ahlelwe emasimini encwadi yekheli le-Outlook oyifunayo.
    • Ungakha amamephu amasha ngokuhudula isihloko sekholomu ensimu oyifunayo.
    • Noma yikuphi ukumephulwa kwangaphambili kwekholomu efanayo kuzothathwa indawo entsha.
  13. Chofoza OK .
  14. Manje chofoza u- Finish .

(Kubuyekezwa ngoMeyi 2016, ihlolwe nge-Outlook 2007 no-Outlook 2016)