Tips About Microsoft Excel And Word Mail Merge Function.

TUTORIAL / TIPS ABOUT MICROSOFT EXCEL AND WORD MAIL MERGE FUNCTION.

     

     1-If you are using numbers or currency, you will get a lot of decimal or no decimals at all                   without notice. Even that in your data has already two decimal places.

     

     2- A few tricks for handling it by using a mail merge switch code.

     

     3- Below are few samples that I’ve list for all of us can manage it.

Basic Mail Merge Tutorial by Khyriel.

Below is an example to perform mail merge with Microsoft Word using the data stored in Microsoft Excel.

Firstly, you must have a data in Microsoft Excel to begin. Like the example below.

No	Name	D.O.B	Employee No.	Basic Pay
1	Ahmad Bin Ali	16.05.1990	V0051	1500.00
2	Sulaiman Bin Mahmud	12.02.1977	V0052	1600.00
3	Zakiah Binti Abdullah	05.08.1980	V0053	1300.00
4	Farrah Binti Kasim	29.07.1985	V0054	1200.00
5	Lisa Binti Abdul Razak	31.12.1995	V0055	900.00

Open blank Word document.