Yuav Hloov Li Cas LibreOffice Spreadsheet rau hauv Database rau Xa Cov Ntawv Sib Koom Ua Ke

Cov txheej txheem:

Yuav Hloov Li Cas LibreOffice Spreadsheet rau hauv Database rau Xa Cov Ntawv Sib Koom Ua Ke
Yuav Hloov Li Cas LibreOffice Spreadsheet rau hauv Database rau Xa Cov Ntawv Sib Koom Ua Ke

Video: Yuav Hloov Li Cas LibreOffice Spreadsheet rau hauv Database rau Xa Cov Ntawv Sib Koom Ua Ke

Video: Yuav Hloov Li Cas LibreOffice Spreadsheet rau hauv Database rau Xa Cov Ntawv Sib Koom Ua Ke
Video: Tshuaj theem vim li cas thiaj tau nqi ?/ Siv kho mob dab tsi?/paris polyphylla use for? 2024, Lub peb hlis ntuj
Anonim

Qhov wikiHow no qhia koj li cas los tsim daim ntawv chaw nyob hauv LibreOffice Calc los siv hauv LibreOffice Writer mail merge. Tom qab koj tsim koj daim ntawv nthuav tawm thiab khaws nws hauv qhov tsim nyog, koj yuav tsum txuas nws mus rau Tus Kws Sau Ntawv ua ntej koj tuaj yeem pib sau cov npe hauv koj daim ntawv. Hmoov zoo, LibreOffice Writer los nrog cov cuab yeej tsim cov ntaub ntawv ceev uas ua rau txheej txheem ua ib qho khoom qab zib.

Cov kauj ruam

Ntu 1 ntawm 3: Tsim Daim Ntawv Teev Npe

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 1
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 1

Kauj Ruam 1. Qhib LibreOffice Calc

Koj yuav pom nws hauv koj lub Windows Start menu lossis koj Mac's Applications folder. Calc yog daim ntawv thov app uas zoo ib yam li Microsoft Excel thiab Google Sheets.

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 2
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 2

Kauj Ruam 2. Sau koj kab taub hau

Koj yuav xav siv cov ntsiab lus tseem ceeb xws li Lub Npe, Chaw Nyob, Xeev thiab Zip, thiab lwm yam. Cov ntawv no yuav tsum mus rau hauv cov cell sib cais hauv thawj kab ntawm daim ntawv nthuav tawm.

  • Nws tuaj yeem pab tau rau daim ntawv lo rau txhua kab ntawv rau qhov tsawg tshaj plaws ntawm cov ntaub ntawv tuaj yeem ua tau. Piv txwv, hloov ntawm ib kab lus hu ua Chaw Nyob, koj tuaj yeem siv StreetAddress, Xeev, thiab Zip. Hloov chaw ntawm ib kab rau Npe, koj tuaj yeem ua FirstName thiab LastName.
  • Cov kab ntawv header tiag yuav tsum yog tus kheej rau koj cov kev xav tau.
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 3
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 3

Kauj Ruam 3. Sau kab ntawv nrog cov ntaub ntawv kom sib koom ua ke

Txhua kab yuav tsum muaj cov ntaub ntawv rau ib tus neeg sib cuag. Tom qab nkag mus rau thawj qhov kev sib cuag ntawm thawj kab uas muaj, nkag mus rau kev sib cuag tom ntej ntawm kab tom ntej, thiab ntxiv rau.

Koj tsis tas yuav siv cov qauv tshwj xeeb lossis cov qauv (xws li cov ntawv loj) vim tias cov ntaub ntawv yuav raug muab los ntawm koj li ntawv xa ua ke

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 4
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 4

Kauj Ruam 4. Txuag cov ntaub ntawv raws li hauv ODF cov ntaub ntawv

Cov ntaub ntawv ODF xaus nrog. ODS cov ntaub ntawv txuas ntxiv, uas yuav zoo li me ntsis txawv, tab sis nws yog qhov tseeb. Txhawm rau txuag daim ntawv nthuav tawm:

  • Nyem rau Cov ntaub ntawv ntawv qhia zaub mov nyob rau sab saud thiab xaiv Txuag raws li.
  • Xauj mus rau daim nplaub tshev uas koj xav khaws cov ntawv. Koj yuav tsum nco ntsoov qhov chaw no.
  • Xaiv ODF Spreadsheet (*.ods) los ntawm "Txuag raws li hom" lossis "Format" nco-down ntawv qhia zaub mov.
  • Nyem Txuag. Txij ntawm no, xav tias dawb los kaw Calc app.

Ntu 2 ntawm 3: Txuas Daim Ntawv Cuam Tshuam

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 5
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 5

Kauj Ruam 1. Qhib Libre Writer

Koj yuav pom nws hauv koj Windows Start menu lossis koj Mac's Applications folder.

Tsis txhob txhawj xeeb txog kev sau koj tsab ntawv lossis daim ntawv tseem tsis tau-koj tsuas yog txuas qhov chaw nyob rau Tus Sau Ntawv rau tam sim no

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 6
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 6

Kauj Ruam 2. Qhib Qhov Chaw Nyob Cov Ntaub Ntawv Tus Kheej

Cov cuab yeej no ua kom yooj yim los tsim cov ntaub ntawv los ntawm koj daim ntawv nthuav tawm. Ua li no:

  • Nyem rau Cov ntaub ntawv cov ntawv qhia zaub mov nyob rau sab saud.
  • Nyem Wizards ntawm cov ntawv qhia zaub mov.
  • Nyem Chaw Nyob Cov Ntaub Ntawv.
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 7
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 7

Kauj Ruam 3. Xaiv "Lwm cov ntaub ntawv sab nraud" thiab nyem Next

Nws yog qhov kev xaiv kawg.

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 8
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 8

Kauj Ruam 4. Nyem rau qhov Settings Button

Lub qhov rais "Tsim Chaw Nyob Cov Ntaub Ntawv" yuav tshwm.

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 9
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 9

Kauj Ruam 5. Xaiv "Spreadsheet" thiab nyem Next

Qhov no qhia Tus Kws Sau Ntawv tias koj tab tom ua haujlwm nrog cov ntawv nthuav tawm.

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 10
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 10

Kauj Ruam 6. Xaiv daim ntawv uas koj tau tsim thiab nyem Next

Txhawm rau ua qhov no, nyem qhov Xauj khawm, taw mus rau daim ntawv nthuav qhia uas muaj chaw nyob (xaus nrog. ODS cov ntaub ntawv txuas ntxiv), thiab ob npaug nyem rau daim ntawv nthuav qhia kom xaiv nws.

Txhawm rau txheeb xyuas tias koj tau xaiv daim ntawv nthuav qhia uas tuaj yeem siv tau, nyem rau Kuaj Kev Sib Txuas khawm ntawm kaum-hauv qab txoj cai. Koj yuav tsum pom cov lus uas hais tias kev sib txuas tau tsim tiav. Yog tias koj pom qhov yuam kev, tej zaum koj tau xaiv cov ntaub ntawv tsis raug lossis khaws nws hauv qhov tsis raug.

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 11
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 11

Kauj Ruam 7. Nyem rau Finish khawm

Tam sim no koj tau txuas nrog daim ntawv nthuav qhia, koj tuaj yeem pib ntshuam cov ntaub ntawv.

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 12
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 12

Kauj Ruam 8. Nyem Next mus txuas ntxiv

Ua tsis nyem lub pob "Ua Haujlwm Hauv Ntej" khawm, vim nws yuav tsis ua haujlwm rau koj daim ntawv teev npe.

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 13
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 13

Kauj Ruam 9. Npe cov ntaub ntawv database (. ODB)

Ua tibzoo saib lub npe cov ntaub ntawv hauv "qhov chaw" teb-cov ntaub ntawv hu ua "Addresses.odb" los ntawm lub neej ntawd. Koj tuaj yeem khaws lub npe ntawd yog tias koj xav tau, lossis hloov nws mus rau lwm yam-tsuas yog nco ntsoov khaws lub. ODB thaum kawg ntawm cov npe ntawv.

  • Yog tias "Txheeb phau ntawv chaw nyob no txhais rau hauv daim ntawv tam sim no" lub npov tau khij, khij nws tam sim no.
  • Daim teb "Lub npe phau ntawv" yog qhov uas cov npe chaw nyob no yuav tshwm nyob rau lwm lub LibreOffice apps. Xav hloov qhov no yog tias koj xav tau.
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 14
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 14

Kauj ruam 10. Nyem Finish

Tam sim no koj daim ntawv nthuav tawm txuas nrog LibreOffice Writer thiab npaj siv rau hauv koj li kev xa ntawv.

Cov ntaub ntawv khaws tseg tseem yuav muaj rau siv yav tom ntej hauv tsab ntawv lossis cov ntaub ntawv ib yam

Ntu 3 ntawm 3: Tsim Koj Cov Ntawv Sib Koom Ua Ke

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 15
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 15

Kauj Ruam 1. Qhib ib daim ntawv tshiab hauv LibreOffice Writer

Yog tias koj twb tau tsim koj daim ntawv foos, daim ntawv lo, lossis lub hnab ntawv, qhib tam sim no.

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 16
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 16

Kauj Ruam 2. Qhib Cov Ntaub Ntawv Cov Ntaub Ntawv

Txhawm rau ua qhov no, nyem qhov Saib ntawv qhia zaub mov nyob rau saum toj, thiab tom qab ntawd xaiv Cov ntaub ntawv. Koj yuav pom qhov tseem ceeb ntawm koj daim ntawv nthuav tawm chaw nyob hauv lub vaj huam sib luag nyob saum toj ntawm daim ntawv. Lub vaj huam sib luag yuav nyob ntawd ua kom yooj yim rau koj.

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 17
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 17

Kauj Ruam 3. Ua daim ntawv raws li koj xav kom nws tshwm

Piv txwv li, yog tias koj tab tom sau ib tsab ntawv, sau tsab ntawv koj xav kom nws zoo li cas.

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 18
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Kauj Ruam 18

Kauj Ruam 4. Luag cov kab ntawv kab ntawv taub hau rau lawv qhov chaw sib xws

Cov ntaub ntawv kab ntawv kab taub hau yog cov ntawv grey saum cov ntaub ntawv chaw nyob hauv lub vaj huam sib luag sab saum toj ntawd. Piv txwv li, yog tias koj tab tom sau tsab ntawv thiab xav kom nws pib nrog "Nyob zoo (lub npe)," koj yuav tsum sau lo lus Nyob Zoo, luag Lub Npe kab ntawv taub hau rau qhov chaw koj yuav ntaus lub npe, thiab tom qab ntawd ntaus tus lej.

Thaum koj rub kab ntawv kab taub hau rau qhov chaw xav tau, nws yuav tshwm nrog daim duab peb sab ntawm ob sab (ex:)

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 19
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 19

Kauj Ruam 5. Txuag koj daim ntawv

Kom paub tseeb tias tsis muaj dab tsi tshwm sim rau koj txoj haujlwm nyuaj, nyem rau Cov ntaub ntawv menu thiab xaiv Txuag raws li. Cov ntaub ntawv yuav tsum tau khaws tseg nrog. ODT cov ntaub ntawv txuas ntxiv, yog li xaiv ODF Text Document (*.odt) los ntawm "Txuag raws li hom" lossis "Format" ntawv qhia zaub mov.

Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 20
Hloov pauv LibreOffice Spreadsheet rau hauv Database rau Mail Merge Documents Step 20

Kauj Ruam 6. Luam koj daim ntawv

Cov kauj ruam los ua qhov no sib txawv nyob ntawm qhov koj tab tom luam ntawv.

  • Yog tias koj luam ib tsab ntawv, nyem rau Cov ntaub ntawv menu thiab xaiv Luam. Koj yuav raug nug yog tias koj xav luam daim ntawv-xaiv Yog lawm thaum nug. Yog tias koj tsis xav sau cov ntawv rau txhua tus neeg hauv daim ntawv teev npe, tuav lub Ctrl (PC) lub Hais kom ua (Mac) qhov tseem ceeb thaum koj nyem qhov koj xav luam tawm. Nyem OK, thiab tom qab ntawv luam tawm raws li xav tau.
  • Yog tias tsim cov ntawv lo, mus rau Cov ntaub ntawv > Tshiab > Cov ntawv, xaiv lub database, rooj, thiab cov teb. Hauv qab, xaiv hom ntawv daim ntawv uas koj tab tom luam tawm rau (piv txwv li, Avery A4) thiab lwm yam kev nyiam ua daim ntawv lo ntxiv, thiab tom qab ntawd nyem Txuag. Los ntawm qhov ntawd, ntawm Kev xaiv tab, click Synchronize txheem, thiab ces Cov ntaub ntawv tshiab los tsim koj daim ntawv lo. Tom qab ntawv koj tuaj yeem luam daim ntawv ntawd raws li xav tau los ntawm kev xaiv Cov ntaub ntawv > Luam.

Pom zoo: