I created a mailmerge macro some time ago. It uses 944 fields in the source file. The data source is a tab delimited text file and the macro uses an odbc connection



After a computer update, using this macro now triggers a "please select column and row delimiter" dialog box, which rarely popped up in the past.


Currently the macro works fine, I just have to select the column an row delimiter for each merged document (which is tedious and a lot)


additionally the dialog box doesn't pop up if I limit the number of fields to less than 255 in the data source (which wont work in a production environment)

I would like to find a way to auto determine the column delimiter type or somehow programatically solve the issue. selecting the column delimiter for each document is excessive at this point. I reviewed the methods for mailmerge.opendatasource and there appears to be nothing for setting a format or delimiter.

Any ideas or guidance is greatly appreciated.