Updated description and attached sample file on 7/5: please re-read! Have a membership list in .doc and .rtf and want to import this list into Access for retieval and query purposes. Have worked with Microsoft to create a macro that transfers the data into Access, but it produces bizarre results when there is more than 2 carriage returns in a field. (Access only takes 2 carriage returns per record delimited by memo into single fields.) Your program needs to reduce the number of carriage returns to no more than 2 in each field.
Complete source code of all programming work done Write simple code to resolve carriage return issue
## Deadline information
ASAP High Urgency