We have loan approval Word documents that contain numerous tables of customer information, often redundant. We want to be able to enter common borrower data in one place and have it replicated where needed, and this applies to potentially multiple secondary borrowers in the same document. We tried using Insert - Quick Parts - Document Property, which works fine but is limited to 15 values, and we need more. I'm trying to create VBA functions and pull the values into table formulas, but I'm getting a syntax error. For example, in the document code, I have:
In the table, if I put a formula: =Bor1Name, I get "!Undefined Bookmark, BOR1NAME". If I put =Bor1Name() I get "!Syntax Error, ("

Any suggestions on how to get the formula/function to work? Or is there a better way to accomplish what we need? Links to data in an Excel document won't work for this app, since the data is coming from a web site.