Solvingcorner

Mail merge di Microsoft Word memang banyak berguna untuk pekerjaan sehari-hari, terutama yang berprofesi sebagai administrator dan sekretaris. Sayangnya pengisian database di Word menggunakan Wizard kurang nyaman dan terorganisir.

Let’s say kita akan membuat sebuah surat sederhana. Ikuti langkah-langkah ini, kemudian anda bisa berimprovisasi setelah memahaminya.

Di Microsoft Word ketiklah surat seperti ini (cukup copy paste ke dokumen word anda):

Jakarta, 01 Januari 20xx

Kepada Yth
-NAMA-
-ALAMAT-

Dengan hormat,

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
Why do we use it?

It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ‘Content here, content here’, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for ‘lorem ipsum’ will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).

Hormat kami,

PT. ABCDE

Setelah selesai, save dengan nama mail_merge_example.doc

Kemudian di Microsoft Excel, buatlah data seperti ini, ikuti letak cell persis seperti gambar:

Setelah selesai, savelah dengan nama data_alamat.xls di My Documents.

Kemudian buka kembali file mail_merge_example.doc

Di Microsoft Word, klik View –> Toolbars —> Mail Merge. Anda akan melihat Toolbar seperti ini

Mail Merge Toolbar

Click Icon (Open Data Source) kemudian pilih data source anda yang tadi anda buat di Microsoft Excel (My Documents\data_alamat.xls). Window Select Table akan muncul, beri tanda tick pada First Row of Data Contain Column Header kemudian pilih Sheet1$. Click OK.

Select Table

Disini Dokumen Word anda telah terhubung dengan data_alamat.xls. Sekarang kita akan menggabungkannya.

Langkah-langkah menggabungkan

1. Di surat yang telah anda ketik tadi, hapus tulisan -NAMA- dan -ALAMAT-. Letakkan kursor di bawah Kepada Yth, kemudian click icon (Merge Field).
2. Di Window Merge Field, click Nama kemudian click Insert.
3. Lakukan hal yang sama dengan -ALAMAT-.
   

   Insert Merge Field

4. Hasilnya akan seperti gambar.

   

5. Setelah selesai click icon (Merge to New Document). Pilih All.
6. Tiap lembar berisi record yang berbeda-beda.