How to use excel 2007 & mail merge to generate pay advice for employees.

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:

Get free answers from experts in any of our 300+ topics.
Accept money for answers that you provide.
Communicate privately with other members (PM).
See fewer ads.

wijesekera

Oct 17, 2010, 08:25 AM

I use this function to issue a letter to employees detailing their salary earnings & deductions. Problem is that all the fields (including unwanted fields)in excel workshhet appears in pay advice.(eg. "loan installement" print in pay advice as zero,for those who not obatained loans also.) .I tried " skip record if " rule to overcome this but failed. Help me please.

atr4ug

Jan 9, 2011, 09:54 PM

Try to use if logic
=if(a1=0,"",if(a1="",""))