Hello,
We have a lot of clients having Mail Merge templates with a lot of "normalized" merge fields. They must:
Contain only letters, numbers, and the underscore (_) character
Not exceed 40 characters
We are not aware of all the limitations but have to "normalize" the columns in the data source table to map them to the template's merge fields. Currently we use Word object model and set the data table as a data source of the template. Something like
document.MailMerge.OpenDataSource(...)
then Word "normalize" the fields and they can be returned fom document.MailMerge.DataSource.DataFields
So far, so good but this is extremely slow and we want to write our algorithm for "normalizing". Do you have any similar functionality or know-how of any other limitations?
Regards,
Velislav