Hi
I have a mail merge document which I need to pull in two separate fields from excel, e.g. Insurance and Membership.
The data is many rows (employees), some of which have Insurance, some of which have membership and some of which have both.
The memo should read something like :
Dear xxx
Your amounts for this month are as follows:
Membership: [FIELD VALUE IF APPROPRIATE]
Insurance: [FIELD VALUE IF APPROPRIATE]
Thank you
However, I want to be able to merge the document so that only those that are relevant to the employee show on their memo. For example, Bob may have insurance but not membership, so his memo would read as above, but without the option Insurance. Jane may have both so both headings would appear with the value next to it. I want to avoid producing memos that have a heading with a blank field next to it.
Can anyone point me in the right direction please.
Thank you
Bookmarks