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.

Example.

     1.       To toggle between preview results and switch code, just press Alt-F9.

     2.       It happens when you are using a formula to calculate the data.

No	Without Switch Code	With Switch Code
1	{ MERGEFIELD Basic_2013 }	{ MERGEFIELD Basic_2013 \#0.00 }
	Result - 867.28800000000001	Result - 867.291
2	{ MERGEFIELD Name }	{ MERGEFIELD Name \*Upper }
	Result – Ahmad Bin Ali	Result - AHMAD BIN ALI
3	{ MERGEFIELD MyDate }	{ MERGEFIELD MyDate \@ "d MMM yyyy"}
	09.03.2010	3 Sep 2010

     3.       After you have done insert the switch code, press back Alt-F9. Right click over the Merge    Field  that you have amend just now and select “Update Field”.

             

Update Field

Now it’s all done. Try it. Practice makes perfect and to be a better one.

Notes: Other possible date formatting switches include below. You can swap the d, M, y expressions around, but you must use uppercase 'M's for months and lowercase 'm's are for minutes.

-              \@ "dddd, d MMMM yyyy";       = (Friday, 3 September 2010)
-              \@ "ddd, d MMMM yyyy";          = (Fri, 3 September 2010
-              \@ "dd/MMM/yyyy".                    = (03/Sep/2010)

I hope these tips can help people like me out there.