Thursday, April 4, 2013

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.
Related Posts Plugin for WordPress, Blogger...