First of all I'm on Libre Office. I hope that's ok for me to post here. I believe libre office is a fork of open office so I'm guessing they work the same. If I need to find another forum, sorry. Just let me know.
I've recently moved over to Linux Mint. Previously on windows. All the business documents were constructed in MS word and I'm converting them to ODT format. I have all the mail merge documents set up ok as they are simple enough - apart from one. I'm stumped with this one.
It's a health and safety document. It is linked to the spreadsheet and checks to see if I've entered "Yes" in particular boxes. If it finds yes in a box it inserts all the text from another document. This field is reused multiple times in the document and pulls in all the necessary risk assessments and method statements.
Here is the formula that did the job in MS word. it will explain better than my attempt above what I need to achieve. If anyone is curious by the way, RAMS stands for risk assessment / method statement.
Code: Select all
{ If { MERGEFIELD RAMS 4 Extension ladders } = Yes {INCLUDETEXT “D: \\Documents\\HEALTH & SAFETY\\RAMS generic\\RAMS\\RAMS 4 – Extension ladders.docx” } “”}
Code: Select all
insert field - more fields