html5-img
1 / 24

Latihan Dalam Perkhidmatan

Latihan Dalam Perkhidmatan. 7 Julai 2012 Sabtu. Mail Merge. Dokumen Surat Sampul surat Label Sijil Dokumen lain. Pangkalan Data Nama No K/P Alamat Gred Catatan Lain-lain. Contoh : SIJIL UJIAN LISAN. Data Fields (Medan data). STEP 1. Sediakan pangkalan data dgn Excel:.

gabby
Download Presentation

Latihan Dalam Perkhidmatan

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LatihanDalamPerkhidmatan 7 Julai 2012 Sabtu

  2. Mail Merge Dokumen • Surat • Sampulsurat • Label • Sijil • Dokumen lain • Pangkalan Data • Nama • No K/P • Alamat • Gred • Catatan • Lain-lain

  3. Contoh :SIJIL UJIAN LISAN

  4. Data Fields (Medan data)

  5. STEP 1 • Sediakanpangkalan data dgn Excel: Gunabaris #1 untuk data fields Data fields

  6. ISIKAN DATA BAGI SETIAP PENERIMA (MURID) SAVE FILE AS ……………(eg. Data1)

  7. STEP 2 • Open Word document cth : Sijil.doc

  8. Start Mail Merge

  9. Start Mail Merge

  10. Select Recipients

  11. Select EXCEL Data file from location

  12. Select Table : Sheet1$

  13. Place cursor at 1st point of data entry

  14. Insert Merge Field

  15. 1st Merge Field Inserted

  16. Insert All Your Fields 1 by 1

  17. Preview Results

  18. First recipient

  19. Finish and Merge 1

  20. Finish and Merge 2

  21. Word document with each recipient for each page

  22. Save Letters1 asLisan Print

  23. Save it!

  24. BeneOrasseBeneStuduisse Thank You

More Related