Cara Menggunakan Mail Merge untuk Membuat Label Alamat dengan Excel dan Word

Unduh PDF
Unduh PDF

Jika Anda mempelajari fungsi Mail Merge melalui halaman dukungan Microsoft, Anda mungkin merasa kesulitan. Karena itu, kami akan menjelaskan prosesnya secara bertahap. Artikel ini akan membahas cara membuat berkas alamat di Excel, menggabungkannya di Microsoft Word, dan menambahkan detail lain yang diperlukan. Proses ini akan menghemat waktu Anda dalam membuat label. Jadi, Anda tidak perlu lagi menulisnya dengan tangan!

Catatan: Langkah pada artikel ini adalah untuk Office 2003. Instruksi untuk versi Excel lain mungkin berbeda.

Langkah

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e3\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-1-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e3\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-1-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Sisipkan nama dan alamat dengan format berikut ini:
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6e\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6e\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    • Tuliskan nama depan di kolom A.
    • Tuliskan nama belakang di kolom B.
    • Tuliskan alamat di kolom C.
    • Tuliskan kota di kolom D.
    • Tuliskan kecamatan di kolom E.
    • Tuliskan kode pos di kolom F.
    • Simpan berkas. Pastikan Anda mengingat lokasi penyimpanan dan nama berkas.
    • Tutuplah Microsoft Excel.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9f\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-3-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-3-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9f\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-3-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    • Jika Task Pane belum terbuka di bagian kanan layar, bukalah "View/Task Pane" , kemudian klik opsi tersebut. Task Pane akan terbuka.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/25\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-4-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-4-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/25\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-4-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/69\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-5-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-5-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/69\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-5-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Setelah memilih label, klik "OK" .
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/84\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-6-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-6-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/84\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-6-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-6-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    "Select Recipients".
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/ce\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-7-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-7-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/ce\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-7-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Bukalah berkas tersebut, dan kotak dialog baru akan terbuka. Seluruh penerima akan terpilih. Jika ada penerima yang belum terpilih, klik penerima tersebut, lalu klik "OK" .
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/30\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-8-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-8-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/30\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-8-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    "Arrange your labels".
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/94\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-9-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-9-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/94\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-9-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Biarkan kolom "Database" terpilih, lalu isilah kolom yang ingin Anda pilih sesuai susunannya pada label. Umumnya, susunan yang digunakan pada label adalah Nama Depan, Nama Belakang, Alamat, Kota, Kecamatan, dan Kode Pos. Seluruh entri akan tampil dalam satu baris; abaikan hal tersebut. Setelah selesai memilih, Anda dapat menambahkan spasi atau baris baru pada label. Setelah selesai memilih kolom, klik "OK" . Jika Anda lupa menyisipkan salah satu data (kolom di bagian kanan kursor akan berubah menjadi abu-abu; hal tersebut normal), klik "More items..." kembali dan pilih kolom yang ingin Anda tambahkan. Klik "CLOSE" pada jendela setelah selesai menyisipkan kolom.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/78\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-10-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-10-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/78\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-10-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Saat kolom setelah lokasi berubah menjadi abu-abu, abaikan hal tersebut karena spasi akan ditambahkan, alih-alih menimpa data.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/50\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-11-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/50\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-11-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    • Jika label sudah sesuai dengan kehendak Anda, klik "Update All Labels" . Seluruh data pada kolom akan tersalin pada label.
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/ef\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-12-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-12-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ef\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-12-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    "Preview your labels".
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4f\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-13-Version-2.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4f\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-13-Version-2.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    "Complete the Merge". Di layar ini, Anda dapat menyunting label tertentu atau mencetaknya. Sebaiknya, klik "EDIT INDIVIDUAL LABELS" , dan klik "All" dan "OK" meskipun Anda telah puas. Dengan mengeklik tombol tersebut, Anda dapat mengakses seluruh label.
    • Simpan berkas sebelum melakukan tindakan lain.
  14. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d4\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-14.jpg\/v4-460px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-14.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d4\/Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-14.jpg\/v4-728px-Mail-Merge-Address-Labels-Using-Excel-and-Word-Step-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Alat daring komersial tersebut bisa jadi lebih mudah digunakan dan lebih cepat.
    Iklan

wikiHow Terkait

Cara
Menambah Tanda Centang ke Dokumen Word
Cara
Membuka Proteksi Lembar Kerja Excel
Cara
Membuat Teks Rata Tengah di Microsoft Word
Cara
Menghapus Halaman Kosong di Word
Cara
Mengubah Koma Menjadi Titik pada Microsoft Excel
Cara
Menampilkan Baris Tersembunyi di Excel
Cara
Menyisipkan Gambar di Excel yang Bisa Menyesuaikan Ukuran Sel secara Otomatis
Cara
Mengubah Huruf Kecil Menjadi Huruf Besar di Excel
Cara
Mengubah Dokumen Hasil Scan Ke File Microsoft Word
Cara
Menghilangkan Status 'Read Only' pada Dokumen MS Word
Cara
Menambahkan Nomor Halaman di Microsoft Word
Cara
Menampilkan Kembali Kolom Tersembunyi di Excel
Cara
Membuat Simbol X Garis Atas di Microsoft Word
Cara Mudah Membuat Tanda Panah di Word pada Komputer Windows atau Mac
Iklan

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 22.019 kali.

Apakah artikel ini membantu Anda?

Iklan