I am producing an executive level status report using data downloaded from a TABLEAU report into an .CSV file. I cannot use a Mail Merge because it won't allow me to do what I need to do for the report. The report format is as follows:



Summary page(s) containing a brief summary for each record in the .CSV file. Then after the summary page(s) there is a full page status report for each record in the .CSV file.

Although I cannot use Mail Merge I am using the MailMergeDataSource to open the .CSV file. I am using VBA to iterate through the data source and produce the report, everything is working fine except one thing, any of my data Fields that are longer the 255 characters are being truncated to 255 characters.

I find this strange because everything comes out fine if I use the same data source for an actual Mail Merge. I've done alot of searching on the internet for a solution but none of the suggestions are fixing the issue.