Afternoon everyone

I have an excel mail merge problem I am hoping someone can confirm if it is possible, and if so how to do it.

I am creating contracts for a large number of colleagues. I have the scripts written with blank spaces for the variables relevent to each colleague.

Naturally not all paragraphs will be applicable to each colleague. Rather than have all the letters created, and have to delete the unwanted paragraphs, I'm looking for the contract script not to generate the obsolete paragraphs at all.

I have created a variable for each paragraph, and have broken down the paragraphs into variable chunks e.g. "Your salary is changing from xxxx to xxxx"

Variable 1 contains "Your salary is changing from",
Variable 2 contains "to"

With variables "Pre Salary" & "Post Salary".

My logic in doing it this way is that I can edit the code (and I apologise for my basic understanding of coding language) to read:



(If "Variable 1" <> "", and "variable 2" <> "", and "Pre Salary" <> "", and "Post Salary" <> "" then output "Variable 1", "Pre Salary", "Variable 2", "Post Salary", else "").

Can anyone help me with this?

Regards,