3 Replies Latest reply on Mar 14, 2015 6:54 AM by MW Design

    Is there a limit to the number of columns in a spreadsheet to be used for Data Merge?


      I need 60 fields for each record - my test data of 6 records adds random breaks when exported as a txt file, causing it not to merge correctly and create many extra records with varying fields (about 214 records) when merged.


      I read somewhere it was 20 but this seems rather limiting! I did try reducing my document to 20 column records but I am still having issues with the txt file breaking the record up into mulitple record lines. I have removed the line breaks from the spreadsheet.