I'm creating a Word Data Document from VB for a mailmerge. My problem is that I have over 30 fields and I get an automation error on the following line that it is longer than 255 chars.
wrdDoc.MailMerge.CreateDataSource Name:="C:\Datadoc.doc", HeaderRecord:="Firstname, LastName, and the rest ...."
I can't use short field names - I must keep the original fieldnames. I tried using temporary short names and then trying to modify the FieldNames and/or DataFields properties but I get an error. It appears that you cannot modify these properties in runtime.