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.

Do you get the same result if you open the csv with Excel, save that file in Excel format and then point the mail merge at Excel data instead?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

That suggests your process is treating those fields as text fields, whereas they need to be treated as memo fields.

That said, without seeing either the data source or the intended output, it's impossible to confirm your assessment that mailmerge can't be used.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you for the suggestion but I've tried saving it as an excel file and the data still gets truncated. When I view the records in Excel the data is all there.

In that case, you can either:
• re-arrange the data so the first few records have more than 255 characters in the fields concerned; or
• insert a dummy first record that has more than 255 characters in the fields concerned.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Again, I appreciate the suggestion, but I have already tried this. I've tried multiple times including the "dummy" rows, as many as 10 rows didn't fixt the problem in a 30 row dataset.

Is there a reason you can't use the actual datasource your CSV is produced from?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

The data is downloaded from a Tableau report into the .CSV. I cannot directly access a Tableau report from Word and the report is report is generated using data from multiple data sources.

As I said before:
Likewise, without seeing either the data source or the VBA code you're using, it's impossible to know what the issue is on that front.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]