Hi All,
I have managed to set up my mail merge data in a way that allows me to produce a Remuneration Statement in the exact way i have want and this transposes to word brilliant, where the data is applicable.
My issue is that I have to show 3 years worth of history in the final document, but not all employees are in the schemes over the 3 years (some may be in two schemes for all, some may be in no schemes over the three or some may be in one scheme over the three). The default output is Currently "£-" when i review the merge.
Does anyone know of a way in word/excel via VBA that will allow me to remove the tables if there is no data showing for the employee? Or is the best way going to be to split mail merge files into individual schemes (I want to try and avoid this as much as possible)
I have managed to set up my mail merge data in a way that allows me to produce a Remuneration Statement in the exact way i have want and this transposes to word brilliant, where the data is applicable.
My issue is that I have to show 3 years worth of history in the final document, but not all employees are in the schemes over the 3 years (some may be in two schemes for all, some may be in no schemes over the three or some may be in one scheme over the three). The default output is Currently "£-" when i review the merge.
Does anyone know of a way in word/excel via VBA that will allow me to remove the tables if there is no data showing for the employee? Or is the best way going to be to split mail merge files into individual schemes (I want to try and avoid this as much as possible)
