Click Tips and Trick

<div style="text-align: justify;">Ketika kita membuat sebuah surat yang di tujukan kepada orang banyak dan harus menyebutkan nama dan alamatnya satu persatu, maka hal yang harus dilakukan adalah dengan cara membuat nya dalam bentuk <b>Mail merge</b>.</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><b>Mail Merge</b> tersebut berguna untuk memudahkan kita meng input data nama dan alamat dengan mudah.</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">Dalam pembuatan <b>mail merge</b> yang kita butuhkan adalah dengan membuka program ms word dan ms exel.</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">Mari kita belajar <b>Mail merge</b> bersama - sama.</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><span style="font-size: small;">Langkah pertama kita ketik bagan surat nya di ms word dahulu :</span><span style="font-size: small;"> </span></div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghVahiv9ZiQSF0oOo_I7awT69ih-bVKmetOh_VoFVZR6VA6b14nM8EfbpuZPxrXNfYxFNncwZml2p58X_QPs7B-KBSzTvReNke8Ixq0yztsioyzC_hFG0lxlY7a0FjWr9lw14h-5RznBJy/s1600/mailmerge+2.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghVahiv9ZiQSF0oOo_I7awT69ih-bVKmetOh_VoFVZR6VA6b14nM8EfbpuZPxrXNfYxFNncwZml2p58X_QPs7B-KBSzTvReNke8Ixq0yztsioyzC_hFG0lxlY7a0FjWr9lw14h-5RznBJy/s400/mailmerge+2.png" width="400" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">mail merge</td></tr></tbody></table><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><span style="font-size: small;">Jika sudah buka program<span style="font-family: "Calibri","sans-serif"; line-height: 115%;"> exel dan buat daftar nama dan alamat nya :</span></span><span style="font-size: small;"><span style="font-family: "Calibri","sans-serif"; line-height: 115%;"><span style="font-family: "Calibri","sans-serif"; line-height: 115%;"> </span></span></span></div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgY4pt0VaIk_C8p_1xobBQ2ghqZt7v-Y-9l8K2wnVlIqkDu15sSIqet1ymNDKhwrftYyCghXXG2rj_9vMbC_ez0yl_CCQkR6AJPUotFhLM8BxLG_upoeVCKX1mCAzQOdZEto-suqu7wUXpR/s1600/mailmerge+1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="175" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgY4pt0VaIk_C8p_1xobBQ2ghqZt7v-Y-9l8K2wnVlIqkDu15sSIqet1ymNDKhwrftYyCghXXG2rj_9vMbC_ez0yl_CCQkR6AJPUotFhLM8BxLG_upoeVCKX1mCAzQOdZEto-suqu7wUXpR/s400/mailmerge+1.png" width="400" /></a></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><span style="font-size: small;"><span style="font-family: "Calibri","sans-serif"; line-height: 115%;"><span style="font-family: "Calibri","sans-serif"; line-height: 115%;">Kemudian save as dulu file exel tersebut di tempat yang mudah anda ingat ( misal di deksstop/my document)</span> . </span></span></div><div style="text-align: justify;"><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US;">setelah itu buka kembali lagi ms word yang tadi . kemudian pada deretan menu atas ada tulisan " MAILING " - lalu anda klik dan akan muncul menu baru seperti di bawah ini :</span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5rdHk9enmcIs-y7V71vJ8LrpSY9676eKpv6FwpA1GLwEuTWPooF0Brz-4jVwYrI8p2CKyjBqYpjaK-DJ6iQNdBoqv-twZqn15wfOhqhhB8sxPSrZ6yZRkdx0SO0LGVg-dGVIVMde5262U/s1600/mailmerge+3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="223" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5rdHk9enmcIs-y7V71vJ8LrpSY9676eKpv6FwpA1GLwEuTWPooF0Brz-4jVwYrI8p2CKyjBqYpjaK-DJ6iQNdBoqv-twZqn15wfOhqhhB8sxPSrZ6yZRkdx0SO0LGVg-dGVIVMde5262U/s400/mailmerge+3.png" width="400" /></a></div><div style="text-align: justify;"><br /><span style="font-size: small;"><span style="font-family: "Calibri","sans-serif"; line-height: 115%;"></span></span></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US;">setelah klik menu select recipient akan muncul lagi menu seperti berikut :</span></div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSHCgDZzRoKEWInGTY9Y88sZViFp_diE4ZVqH3EwGoHczxZU9oE6i5TgRUYa6CEimtFGUysG3CgqnwewK2RMZhBb4AM5UXAMRak7gKeusuBGvKY4AB26gqHn6mqBqOTQB9YTVX5YP8Eh8U/s1600/mailmerge+5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSHCgDZzRoKEWInGTY9Y88sZViFp_diE4ZVqH3EwGoHczxZU9oE6i5TgRUYa6CEimtFGUysG3CgqnwewK2RMZhBb4AM5UXAMRak7gKeusuBGvKY4AB26gqHn6mqBqOTQB9YTVX5YP8Eh8U/s400/mailmerge+5.png" width="400" /></a></div><div style="text-align: justify;"><br /></div><span style="font-size: small;"><span style="font-family: "Calibri","sans-serif"; line-height: 115%;"></span></span><br /><div style="text-align: justify;"><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: justify;">kemudian klik menu>> use existing list<<< dan akan muncul menu baru seperti di bawah ini :   </div><div class="separator" style="clear: both; text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWcPt4xRKZHu0chPolU2fCKVZKZyZuQBNKw22FGyOs0YC0sQKCwJT9UYoEIffXLtpkyJyq4oa048RXKiPi_tmDpQr974KF5MPsnng1O6i-Dyd86F47Mh36n6aQeYDqPbmtLFMwtJ-Q4fSj/s1600/mailmerge+6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="252" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWcPt4xRKZHu0chPolU2fCKVZKZyZuQBNKw22FGyOs0YC0sQKCwJT9UYoEIffXLtpkyJyq4oa048RXKiPi_tmDpQr974KF5MPsnng1O6i-Dyd86F47Mh36n6aQeYDqPbmtLFMwtJ-Q4fSj/s400/mailmerge+6.png" width="400" /> </a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: justify;"> </div><div class="MsoListParagraph" style="margin-left: 0cm; mso-add-space: auto;">kebetulan data exel saya tadi saya simpan di dexstop dan saya namakan nama alamat ( tergantung dimana td anda menyimpan dan nama apa yang anda cantumkan tadi ) lalu kita klik file " nama dan alamat " lalu klik "open" seperti gambar di atas.</div><div class="MsoListParagraph" style="margin-left: 0cm; mso-add-space: auto;"><br /></div><br /><div class="separator" style="clear: both; text-align: justify;"></div><div class="separator" style="clear: both; text-align: justify;"> </div><div class="MsoListParagraph" style="margin-left: 0cm; mso-add-space: auto;">setelah klik open akan muncul menu baru seperti gambar di bawah ini :</div><div class="MsoListParagraph" style="margin-left: 0cm; mso-add-space: auto;"><br /></div><div class="MsoListParagraph" style="margin-left: 0cm; mso-add-space: auto;"><br /></div><br /><div class="MsoListParagraph" style="margin-left: 21.3pt; text-align: justify; text-indent: -21.3pt;"><span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"></span></span></span></div><div class="MsoListParagraph" style="margin-left: 21.3pt; text-align: justify; text-indent: -21.3pt;"><span style="font-size: small;"><span style="font-family: "Calibri","sans-serif"; line-height: 115%;"><br /></span></span></div><div class="MsoListParagraph" style="margin-left: 21.3pt; text-align: justify; text-indent: -21.3pt;"><br /></div>   <br /><br /><div style="text-align: justify;"><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US;"><br /></span></div>

CARA MEMBUAT MAIL MERGE DI MS WORD 2007

Ketika kita membuat sebuah surat yang di tujukan kepada orang banyak dan harus menyebutkan nama dan alamatnya satu persatu, maka hal yang ha...

Baca selengkapnya »

CARA MEMBERI WARNA TULISAN BIAR TAMPAK JELAS / HIGHT LIGTING

CARA MEMBUAT MAIL MERGE DI MS WORD 2007

Popular Posts

Categories