I need to export a report to a text file to be read into another application. Although the report in print preview view looks fine, when I export it, the text version of the report has a blank line every 3-5 lines. Can anyone help on this?

Export the query the report is based on using the TransferText Method. If you want to create a fixed width file rather than a delimited one, you'll need to export the query once manually using the File/Save As menu items. The wizard will walk you through creating the file. When you get to the final form, click the advanced button to get to the option to save the export spec. Once you have named and saved the spec, you can reference it in the TransferText Method to automate the process.