I have created a simple table in Access 2000 containing just two fields in each record: Name and Contents. I have around 200 lines in the table (200 records) so there are 200 Names with 200 corresponding pieces of associated text in the Contents field.
I want to create a separate RTF file for each separate record that contains the text from the Contents field and named after the Name field thus:
Name Content
file1 blah, blah, blah, blah
file2 yada, yada, yada, yada
file3 etc
The desired result would be a file named file1.rtf containing just the text blah, blah, blah, blah
and a file named file2.rtf containing just the text yada, yada, yada, yada
all the way down the list of 200 records.
Help!!!