We are exploring the possibility of using of Word mail merges for some of our subscription renewal forms. The idea would be to save the renewal data from the Tessitura Subs Renewal Notices report to excel. That output would then be the data source for a mail merge.
Having not done mail merges in years, the syntax needed for the pkg/seat info area is really throwing me for a loop. Since the excel file has a very large number of columns for the pkg/seat info that may or may not exist for a given customer, I end up with many lines of IF statements to check for the existance of said column data. My problem is that if nothing exists, I return an empty string "" but still end up w/ a blank line in Word, which means that the template output does not shrink/wrap up. I feel like there has to be a way to get rid of this empty line...any ideas?
Also, does anyone have a subscription renewal notice word template that they would be willing to share so I can reference it?