Cara Membuat Mail Merge pada MS Word dengan Data dari Excel

Anda ingin mencetak beberapa dokumen yang berasal dari satu dokumen word yang sama tapi beberapa isinya berubah-ubah seperti nama, alamat, dan cabang?

Jawabannya adalah fasilitas Mail Merge. Dan fasilitas ini adalah salah yang paling banyak digunakan oleh diantaranya oleh para sekretaris dan admin untuk membuat surat undangan, membuat sertifikat, amplop, dan lain-lain.

Sebagai contoh untuk artikel ini, penulis akan mengirim laporan bonus bulanan buat para sales. Data sumber akan menggunakan data dari Excel 2010 dan aplikasi Word juga versi 2010.
  1. Jalankan apikasi Excel, dan buat worksheet dengan data seperti terlihat pada gambar berikut. Namakan file tersebut data_input.xlsx. File tersebut juga dapat Anda download dari link disini.



  2. Buat dokumen word sebagai dasar untuk mail merge ke dokumen Excel di atas. Dokumennya dapat Anda download disini.



  3. Pada menu bar (ribbon) dokumn Word, klik tab Mailings.



  4. Pilih menu Select Recipients | Use Existing List..., dan ambil file Excel yang telah Anda buat atau download tadi.



  5. Pada dialog Select Table, pilih Sheet1$ dan klik OK. Kita pilih Sheet1 karena kebetulan data yang saya masukkan berada di sheet pertama.



  6. Perhatikan bahwa beberapa menu mail merge yang sebelumnya tidak aktif sekarang menjadi aktif. 
  7. Tempatkan cursor pada bagian entri Nama, dan pilih menu Insert Merge Field | Nama.



  8. Field Nama akan dimasukkan ke dokumen dengan format <<Nama>>.



  9. Dengan cara yang sama masukkan Periode, Nama, Periode dan Jumlah Bonus pada dokumen tersebut.



  10. Sekarang kita akan coba lihat dokumen yang digabungkan dengan data tersebut. Klik tombol Preview Results.



  11. Terlihat dokumen sudah tergabung, coba lakukan navigasi data dengan mengklik panah kanan / kiri di group Preview Results.



  12. Sekarang Anda siap mencetak atau mengirimkan dokumen ini. Untuk mencetak dokumen, klik menu Finish & Merge | Print Documents... dan ikuti langkah print seperti yang biasa Anda lakukan.



  13. Selesai.

37 comments:

  1. terima kasih,
    info nya mantaps!
    bisa dicoba!

    ReplyDelete
    Replies
    1. Sama-sama. Senang bisa bermanfaat. Jika ada saran dan masukan bisa dialamatkan ke twitter kami @BelajarExcel atau user group facebook kami di https://www.facebook.com/groups/belajarexcelinfo/.

      Terima kasih!

      Delete
  2. gan mau nnya ketika mailing kok format Rp nya gak ikut masuk..?

    ReplyDelete
  3. thnks gan
    tugas ane bisa slse deh
    postingannya bermanfaat :)

    ReplyDelete
  4. wew, what an amazing post !!!
    thanks for the information :D

    ReplyDelete
  5. Mantap Gan,,, makasih,,,,,
    sangat bermanfaat

    ReplyDelete
  6. gmn cara menampilkan titik pada hasil printx gan

    ReplyDelete
  7. The attention to ground truth offers ascend to perceptions which qualify themselves as labeled information.ExcelR Data Science Courses

    ReplyDelete
  8. Microsoft Office is very important for any Windows users, but it costs money. But as users, we are always keen to know about method where we can get some app or service for free. microsoft office key

    ReplyDelete
  9. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data science course

    ReplyDelete
  10. Bagaimana cara menghilangkan angka dibelakang koma, Min?

    ReplyDelete
  11. I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... ms office 2007 download with key

    ReplyDelete
  12. Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.

    Data Science In Banglore With Placements
    Data Science Course In Bangalore
    Data Science Training In Bangalore
    Best Data Science Courses In Bangalore
    Data Science Institute In Bangalore

    Thank you..

    ReplyDelete
  13. The writer is enthusiastic about purchasing wooden furniture on the web and his exploration about the best wooden furniture has brought about the arrangement of this article.
    data scientist course in hyderabad

    ReplyDelete
  14. Thanks for posting the best information and the blog is very important.digital marketing institute in hyderabad

    ReplyDelete
  15. Thanks for posting the best information and the blog is very important.artificial intelligence course in hyderabad

    ReplyDelete
  16. Thanks for such a great post and the review, I am totally impressed! Keep stuff like this coming.
    data scientist training and placement in hyderabad

    ReplyDelete
  17. Thanks for posting the best information and the blog is very important.data science institutes in hyderabad

    ReplyDelete
  18. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this…

    AWS Training in Hyderabad

    ReplyDelete
  19. I was actually browsing the internet for certain information, accidentally came across your blog found it to be very impressive. I am elated to go with the information you have provided on this blog, eventually, it helps the readers whoever goes through this blog. Hoping you continue the spirit to inspire the readers and amaze them with your fabulous content.

    Data Science Course in Faridabad

    ReplyDelete
  20. Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing. data analytics course in delhi

    ReplyDelete
  21. Great to become visiting your weblog once more, it has been a very long time for me. Pleasantly this article i've been sat tight fosuch a long time. I will require this post to add up to my task in the school, and it has identical subject along with your review. Much appreciated, great offer. data science course in nagpur

    ReplyDelete
  22. Please share this more. Thanks for sharing useful information and don't forget to share useful information.If you are flying to your destination and transiting through Turkey, you will need to obtain a Visa Transit Turkey. This visa allows you to travel through Turkey.

    ReplyDelete
  23. Thanks for posting the best information and the blog is very good.data science course in Lucknow

    ReplyDelete
  24. This is a wonderful inspiring article. I am practically satisfied with your great work. You have really put together extremely helpful data. Keep it up.. Are you planning to visit Kenya?For this, you need to fill the Kenya Visa Application Form and pay the kenya e visa fees online.

    ReplyDelete
  25. Thank you The international travelers who traveling to Kenya need Kenyan visa. That they can apply online and can get the 24*7 customer assistant.

    ReplyDelete
  26. Your blog is very informative and useful. Most travelers don't know how much Indian visa fees are, so must check about it.

    ReplyDelete
  27. Hi, Thanks for sharing nice articles...

    Online Data Entry

    ReplyDelete
  28. That's great to find interesting and attractive information. This blog is awesome... And the post is amazing, and I really enjoyed reading it... required eligibility / documents for India eVisa, Required document & Eligibility check online via India e visa website and read all info here.

    ReplyDelete

  29. I think this is an informative post and it is very useful and informative. So, I would like to thank you for the effort you put into writing this article. The Indian e visa eta or Electronic Visa (eTV) is an online travel authorization. You can fill an Indian e visa application via the India e visa online website.

    ReplyDelete

  30. I think this is an informative post and it is very useful and informative. So, I want to thank you for the effort you put into writing this article. India introduces a new air suvidha self declaration form to help stop the spread of COVID-19. Indian self declaration form registration, You can fill online India self declaration form & read online required documents for self declaration form via India visas website.

    ReplyDelete
  31. I really appreciate the value of this article which is very informative and innovative with updated information. Thanks a lot. India tourist visa for US citizens is available in the type of 30days, 1 year and 5 years visa also which is easy to get and track by Online process.

    ReplyDelete
  32. wow . It is an imperative blog. that understands the value of time. Saudi Arabia tourist visa application process is a very fast and secure online visa system for all the travelers who want to come to Saudi for tourist purposes. . Last time when I applied for our tourist visa I filled that form in only 15 min.

    ReplyDelete

Launching E-BOOK EIUG: Form Entry Sederhana dengan Excel VBA

Pengunjung BelajarExcel.info Yang Saya Hormati, Pada tanggal 14 Juni 2014,Excel Indonesia User Group (EIUG) yang merupakan salah satu k...