Cov txheej txheem:

Yuav ua li cas luam ntau email chaw nyob ntawm Excel rau Outlook?
Yuav ua li cas luam ntau email chaw nyob ntawm Excel rau Outlook?

Video: Yuav ua li cas luam ntau email chaw nyob ntawm Excel rau Outlook?

Video: Yuav ua li cas luam ntau email chaw nyob ntawm Excel rau Outlook?
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Hlis ntuj nqeg
Anonim

Import hu los ntawm Excel rau Outlook

  1. Qhib Outlook , mus rau Cov Ntaub Ntawv> Qhib & Export thiab nyem qhov kev xaiv Ntshuam / Export.
  2. Koj yuav tau txais Ntshuam thiab Export Wizard.
  3. Ntawm Ntshuam Cov Ntaub Ntawv Cov kauj ruam ntawm tus wizard, xaiv Comma SeparatedValues thiab nyem Next.
  4. Nyem rau ntawm Browse khawm thiab nrhiav qhov.
  5. Nyem lub khawm Ntxiv mus xaiv qhov chaw rau koj emails .

Ib yam li ntawd, kuv puas tuaj yeem luam thiab muab cov npe email chaw nyob ntawm Excel rau Outlook?

Nias Ctrl-C lossis right-click Luam . Nyem rau ntawm anempty cell nyob qhov twg ntawm daim ntawv nthuav qhia los yog tsim ib daim ntawv qhia ib ntus tshiab. Right-click thiab xaiv " Muab tshuaj txhuam tshwj xeeb" Xaiv "Tag nrho" thiab xaiv "Transpose" ces nyem "OK"

Qhov thib ob, Kuv yuav xa email loj npaum li cas los ntawm Excel daim ntawv nthuav qhia? Xa email loj los ntawm Excel 2007 Phau ntawv Qhib Outlook thiab txo nws. Qhib Lo Lus thiab ntaus koj li email raws li xav tau. Mus rau "Mailings" tab ntawm kab thiab nyem rau "Start Xa ntawv Merge" khawm. Xaiv " Email Cov lus" hauv cov ntawv qhia zaub mov.

Xav txog qhov no, kuv yuav xa ntau emails ntawm Excel rau Outlook li cas?

Xa cov lus email

  1. Hloov mus rau Mailings ribbon.
  2. Nyem rau ntawm Finish & Merge ntawv qhia zaub mov thiab xaiv Xa E-MailMessages xaiv.
  3. Los ntawm cov ntawv qhia zaub mov nco-down, xaiv daim teb uas muaj qhov chaw nyob ntawm txhua tus neeg tau txais.
  4. Hauv lub thawv ntawv kawm, nkag mus rau cov kab ntawv uas siv rau theemail lus.

Kuv yuav luam thiab paste ntau email chaw nyob li cas?

Tam sim no hais tias tag nrho cov neeg tau txais kev pom zoo, nias CTRL + C rau luam lawv los yog txoj nyem rau ntawm qhov xaiv chaw nyob thiab xaiv Luam . Nias lub pob "AddMembers" thiab xaiv "Los ntawm Chaw nyob Phau ntawv". Muab koj tus cursor tso rau hauv ib sab ntawm lub pob "Cov tswv cuab->". Nias CTRL + V rau muab tshuaj txhuam tus luam qhov chaw nyob.

Pom zoo: