Berikut Trik dan langkahnya
Langkah pertama
Membuat teks naskah MC sebelum penceramah naik mimbar untuk kultum subuh dan tarawih (postingan yang lalu)
Langkah kedua
menyiapkan tabel petugas dengan judul kolom sebagai berikut
Contoh tabel Tarawih
|
NO |
Kultum |
Hari |
Tanggal |
haridepan |
tgldepan |
MC |
PENCERAMAH |
Penceramah depan |
|
1 |
Tarawih |
SELASA |
13APRIL2021 |
RABU |
14APRIL2021 |
|
|
|
|
2 |
Tarawih |
RABU |
14APRIL2021 |
KAMIS |
15APRIL2021 |
|
|
|
|
3 |
Tarawih |
KAMIS |
15APRIL2021 |
JUM'AT |
16APRIL2021 |
|
|
|
|
4 |
Tarawih |
JUM'AT |
16APRIL2021 |
SABTU |
17APRIL2021 |
|
|
|
|
5 |
Tarawih |
SABTU |
17APRIL2021 |
AHAD |
18APRIL2021 |
|
|
|
|
6 |
Tarawih |
AHAD |
18APRIL2021 |
SENIN |
19APRIL2021 |
|
|
|
|
7 |
Tarawih |
SENIN |
19APRIL2021 |
SELASA |
20APRIL2021 |
|
|
|
|
8 |
Tarawih |
SELASA |
20APRIL2021 |
RABU |
21APRIL2021 |
|
|
|
|
9 |
Tarawih |
RABU |
21APRIL2021 |
KAMIS |
22APRIL2021 |
|
|
|
|
10 |
Tarawih |
KAMIS |
22APRIL2021 |
JUM'AT |
23APRIL2021 |
|
|
|
|
11 |
Tarawih |
JUM'AT |
23APRIL2021 |
SABTU |
24APRIL2021 |
|
|
|
|
12 |
Tarawih |
SABTU |
24APRIL2021 |
AHAD |
25APRIL2021 |
|
|
|
|
13 |
Tarawih |
AHAD |
25APRIL2021 |
SEN IN |
26APRIL2021 |
|
|
|
|
14 |
Tarawih |
SEN IN |
26APRIL2021 |
SELASA |
27APRIL2021 |
|
|
|
|
15 |
Tarawih |
SELASA |
27APRIL2021 |
RABU |
28APRIL2021 |
|
|
|
|
16 |
Tarawih |
RABU |
28APRIL2021 |
KAMIS |
29APRIL2021 |
|
|
|
|
17 |
Tarawih |
KAMIS |
29APRIL2021 |
JUM'AT |
30APRIL2021 |
|
|
|
|
18 |
Tarawih |
JUM'AT |
30APRIL2021 |
SABTU |
01MEI 2021 |
|
|
|
|
19 |
Tarawih |
SABTU |
01MEI 2021 |
AHAD |
02MEI 2021 |
|
|
|
|
20 |
Tarawih |
AHAD |
02MEI 2021 |
SENIN |
03MEI 2021 |
|
|
|
|
21 |
Tarawih |
SENIN |
03MEI 2021 |
SELASA |
04MEI 2021 |
|
|
|
|
22 |
Tarawih |
SELASA |
04MEI 2021 |
RABU |
05MEI 2021 |
|
|
|
|
23 |
Tarawih |
RABU |
05MEI 2021 |
KAMIS |
06MEI 2021 |
|
|
|
|
24 |
Tarawih |
KAMIS |
06MEI 2021 |
JUM'AT |
07MEI 2021 |
|
|
|
|
25 |
Tarawih |
JUM'AT |
07MEI 2021 |
SABTU |
08MEI 2021 |
|
|
|
|
26 |
Tarawih |
SABTU |
08MEI 2021 |
AHAD |
09MEI 2021 |
|
|
|
|
27 |
Tarawih |
AHAD |
09MEI 2021 |
SENIN |
10MEI 2021 |
|
|
|
|
28 |
Tarawih |
SENIN |
10MEI 2021 |
SELASA |
11MEI 2021 |
|
|
|
|
29 |
Tarawih |
SELASA |
11MEI 2021 |
|
|
|
|
|
Data tabel Subuh
|
NO |
Kultum |
Hari |
Tanggal |
hrdpn |
tgldpn |
MC |
PENCERAMAH |
PENCDPAN |
|
2 |
Subuh |
RABU |
14APRIL2021 |
KAMIS |
15APRIL2021 |
|
|
|
|
3 |
Subuh |
KAMIS |
15APRIL2021 |
JUM'AT |
16APRIL2021 |
|
|
|
|
4 |
Subuh |
JUM'AT |
16APRIL2021 |
SABTU |
17APRIL2021 |
|
|
|
|
5 |
Subuh |
SABTU |
17APRIL2021 |
AHAD |
18APRIL2021 |
|
|
|
|
6 |
Subuh |
AHAD |
18APRIL2021 |
SENIN |
19APRIL2021 |
|
|
|
|
7 |
Subuh |
SENIN |
19APRIL2021 |
SELASA |
20APRIL2021 |
|
|
|
|
8 |
Subuh |
SELASA |
20APRIL2021 |
RABU |
2 1APRIL2021 |
|
|
|
|
9 |
Subuh |
RABU |
2 1APRIL2021 |
KAMIS |
22APRIL2021 |
|
|
|
|
10 |
Subuh |
KAMIS |
22APRIL2021 |
JUM'AT |
23APRIL2021 |
|
|
|
|
11 |
Subuh |
JUM'AT |
23APRIL2021 |
SABTU |
24APRIL2021 |
|
|
|
|
12 |
Subuh |
SABTU |
24APRIL2021 |
AHAD |
25APRIL2021 |
|
|
|
|
13 |
Subuh |
AHAD |
25APRIL2021 |
SENIN |
26APRIL2021 |
|
|
|
|
14 |
Subuh |
SENIN |
26APRIL2021 |
SELASA |
27APRIL2021 |
|
|
|
|
15 |
Subuh |
SELASA |
27APRIL2021 |
RABU |
28APRIL2021 |
|
|
|
|
16 |
Subuh |
RABU |
28APRIL2021 |
KAMIS |
29APRIL2021 |
|
|
|
|
17 |
Subuh |
KAMIS |
29APRIL2021 |
JUM'AT |
30APRIL2021 |
|
|
|
|
18 |
Subuh |
JUM'AT |
30APRIL2021 |
SABTU |
01MEI2021 |
|
|
|
|
19 |
Subuh |
SABTU |
01MEI2021 |
AHAD |
02MEI2021 |
|
|
|
|
20 |
Subuh |
AHAD |
02MEI2021 |
SEN IN |
03MEI2021 |
|
|
|
|
21 |
Subuh |
SEN IN |
03MEI2021 |
SELASA |
04MEI2021 |
|
|
|
|
22 |
Subuh |
SELASA |
04MEI2021 |
RABU |
05MEI2021 |
|
|
|
|
23 |
Subuh |
RABU |
05MEI2021 |
KAMIS |
06MEI2021 |
|
|
|
|
24 |
Subuh |
KAMIS |
06MEI2021 |
JUM'AT |
07MEI2021 |
|
|
|
|
25 |
Subuh |
JUM'AT |
07MEI2021 |
SABTU |
08MEI2021 |
|
|
|
|
26 |
Subuh |
SABTU |
08MEI2021 |
AHAD |
09MEI2021 |
|
|
|
|
27 |
Subuh |
AHAD |
09MEI2021 |
SENIN |
10MEI2021 |
|
|
|
|
28 |
Subuh |
SENIN |
10MEI2021 |
SELASA |
11MEI2021 |
|
|
|
|
29 |
Subuh |
SELASA |
11MEI2021 |
RABU |
12MEI2021 |
|
|
|
|
30 |
Subuh |
RABU |
12MEI2021 |
|
|
|
|
|
Langkah ketiga
Mengkoneksikan data tabel dengan teks naskah MC dengan cara
1. buka dokumen naskah MC
2. Pilih menu Mailings - start Mail merge - Step by step Mail Merge Wizardz - Klik Next Wizard hingga langkah ketiga 3 - pilih browse kemudian pilih data tabel yang sudah disediakan -
3. Insert merge field (memposisikan) judul kolom sesuai dengan kebutuhan data yang akan diisi
Langkah keempat
Mencetak (print) hasil merge dengan cara Mailings - finish & merge - print
