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.
- 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.
- Buat dokumen word sebagai dasar untuk mail merge ke dokumen Excel di atas. Dokumennya dapat Anda download disini.
- Pada menu bar (ribbon) dokumn Word, klik tab Mailings.
- Pilih menu Select Recipients | Use Existing List..., dan ambil file Excel yang telah Anda buat atau download tadi.
- Pada dialog Select Table, pilih Sheet1$ dan klik OK. Kita pilih Sheet1 karena kebetulan data yang saya masukkan berada di sheet pertama.
- Perhatikan bahwa beberapa menu mail merge yang sebelumnya tidak aktif sekarang menjadi aktif.
- Tempatkan cursor pada bagian entri Nama, dan pilih menu Insert Merge Field | Nama.
- Field Nama akan dimasukkan ke dokumen dengan format <<Nama>>.
- Dengan cara yang sama masukkan Periode, Nama, Periode dan Jumlah Bonus pada dokumen tersebut.
- Sekarang kita akan coba lihat dokumen yang digabungkan dengan data tersebut. Klik tombol Preview Results.
- Terlihat dokumen sudah tergabung, coba lakukan navigasi data dengan mengklik panah kanan / kiri di group Preview Results.
- 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.
- Selesai.
terima kasih,
ReplyDeleteinfo nya mantaps!
bisa dicoba!
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/.
DeleteTerima kasih!
thx mas bro
ReplyDeletegan mau nnya ketika mailing kok format Rp nya gak ikut masuk..?
ReplyDeletethnks gan
ReplyDeletetugas ane bisa slse deh
postingannya bermanfaat :)
wew, what an amazing post !!!
ReplyDeletethanks for the information :D
Mantap Gan,,, makasih,,,,,
ReplyDeletesangat bermanfaat
gmn cara menampilkan titik pada hasil printx gan
ReplyDeleteThank u
ReplyDeleteThe attention to ground truth offers ascend to perceptions which qualify themselves as labeled information.ExcelR Data Science Courses
ReplyDeleteMicrosoft 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
ReplyDeleteBagaimana cara menghilangkan angka dibelakang koma, Min?
ReplyDeleteI’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
ReplyDeletehttps://digitalweekday.com/
ReplyDeletehttps://digitalweekday.com/
https://digitalweekday.com/
https://digitalweekday.com/
https://digitalweekday.com/
https://digitalweekday.com/
https://digitalweekday.com/
https://digitalweekday.com/
https://digitalweekday.com/
ReplyDeletehttps://digitalweekday.com/
https://digitalweekday.com/
https://digitalweekday.com/
https://digitalweekday.com/
https://digitalweekday.com/
https://digitalweekday.com/
https://digitalweekday.com/
Your blog is very informative and useful. Most travelers don't know how much Indian visa fees are, so must check about it.
ReplyDeleteHi, Thanks for sharing nice articles...
ReplyDeleteOnline Data Entry
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
ReplyDeleteI 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.
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.
ReplyDeletewow . 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.
ReplyDeletethankyou
ReplyDeleteblogs
"Cara Membuat Mail Merge pada MS Word dengan Data dari Excel" provides a step-by-step guide on how to create personalized documents by merging data from Excel into Microsoft Word. This process allows users to automate the creation of letters, labels, or envelopes, enhancing efficiency and accuracy in document generation. By following the outlined steps, users can effectively utilize their data for various communication needs.
ReplyDeleteData Science Courses in Kolkata
"Cara Membuat Mail Merge pada MS Word dengan Data dari Excel" provides a step-by-step guide on how to efficiently create personalized documents using Mail Merge in Microsoft Word by utilizing data from Excel spreadsheets. The article likely covers the necessary preparations, including organizing data in Excel, setting up the Mail Merge in Word, and finalizing the merged documents. It may also offer tips for common pitfalls and best practices to ensure a smooth merging process, making it a valuable resource for users looking to streamline their document creation tasks.
ReplyDeleteData Science Courses in Kolkata
This article provides a clear and concise guide on how to perform a Mail Merge in MS Word using data from Excel. The step-by-step instructions make it accessible for users of all skill levels, particularly for administrative professionals looking to streamline tasks like creating invitations, certificates, and reports. The inclusion of screenshots and specific menu selections enhances understanding, ensuring users can follow along easily. The example of sending bonus reports to sales staff is practical and relatable, demonstrating the real-world application of Mail Merge. Overall, this is a valuable resource for anyone looking to efficiently manage personalized documents! Data science courses in Gurgaon
ReplyDeleteThis is exactly what I was looking for! Your posts are always clear and full of great advice. Keep up the awesome work!
ReplyDeleteData science courses in Dubai
This article provides a clear and practical guide on using Mail Merge in MS Word with data from Excel. It's an incredibly useful feature, especially for tasks like generating personalized documents such as invitations, certificates, or reports. Data science courses in Visakhapatnam
ReplyDelete
ReplyDeleteThis is a great guide on using Mail Merge in MS Word with data from Excel! The step-by-step instructions are clear and easy to follow, making it perfect for anyone looking to automate document creation for tasks like sending reports or invitations. A very helpful tutorial for beginners!
Data science courses in Gujarat
Mail merge di MS Word memungkinkan Anda untuk menggabungkan data dari Excel ke dalam dokumen Word, seperti surat atau label. Prosesnya dimulai dengan menyiapkan dokumen di Word, kemudian mengimpor data dari Excel, dan terakhir menggabungkan data tersebut ke dalam dokumen dengan mengatur field yang sesuai. Ini sangat berguna untuk pengiriman surat massal atau pembuatan dokumen personalisasi dalam jumlah besar.
ReplyDeleteData science courses in Pune