Mail merge is merging into one file but not multiple files

Hi, I’ve successfully used Mail Merge to create a text document (answers to a questionnaire) with multiple merge fields in the document. But I need to create 50 individual files. I’ve been able to merge all 50 records into one document but when I select “multiple files” each one has the title of the merge field where the data should be. This is when I try to create a Word 97-2003 document and an ODF document. I WAS able to create 50 individual pdfs no problem. And yes, I am selecting the whole column of the database and dragging it into the document. What is wrong, help?