Hi,
one option would be to add the signature lines for each advisor in the data file, one column per signature line. If you're using Excel as your data source, you could auto-fill these columns from a table where all your advisors are listed via VLOOKUP.
Alternatively, you could use Word to check the name of the Advisor and add the signature lines based on the advisor name with an IF statement in Word. Looks ugly, something like:
Code:
{ IF { MERGEFIELD advisor }="Bill Gates" "Ex Microsoft CEO" { IF { MERGEFIELD advisor }="Steve Jobs" "Apple CEO" "Sales Representative" } }
I'm not sure how many nesting levels can be achieved, but I hope you get the general idea.
Linear Mode
