BAT File VBA - Vary based on number of rows in worksheet

I have a VBA that is creating a .BAT file and running it. In the script there is a part I need to alter. Right now it is:

Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E2").Value

This is printing to the Batch File the contents of "Sheet 7" cell E2.
What I NEED it to do is look at sheet 7 and for each row print the corresponding cell in column E.

So for example if there were 10 rows on sheet 7 (Row 1 is a header) the result in the VBA would be:

Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E2").Value
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E3").Value
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E4").Value
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E5").Value
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E6").Value
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E7").Value
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E8").Value
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E9").Value
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E10").Value
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E11").Value


If there were only 3 rows the result would be:

Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E2").Value
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E3").Value
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E4").Value

How would I do this?
Thanks

Thanks for the reply. Would I paste this code in to my existing module? How would it fit in to my existing script? Here's the full script:

Public Sub TEST()
Application.ScreenUpdating = False
Const MY_FILENAME = "TEST.BAT"

Dim FileNumber As Integer
Dim retVal As Variant

FileNumber = FreeFile

Open MY_FILENAME For Output As #FileNumber
Print #FileNumber, WriteLine; ThisWorkbook.Sheets(7).Range("E2").Value
Close #FileNumber

retVal = Shell(MY_FILENAME, vbNormalFocus)

If retVal = 0 Then
MsgBox "An Error Occured"
Close #FileNumber
End
End If

UpdateLogAfterConvert

ActiveWorkbook.Save

End Sub

Thanks Andy. That did the trick perfectly. You guys are awesome!

Nicely done! Cheers.

One more thought on this. This script is assuming the information is always in "Sheet 7" of "this workbook". What would be the best way make the file and location user definable so if the data is in another sheet or even workbook the user can specify and it will populate the VBA. For example, I also have a button that prompts the user for a directory and populates a corresponding cell with that location. Could I do the same with workbooks, worksheets, and columns? A user could click a button/or buttons and browse for the excel file and populate a cell. The VBA would run based on this rather than a "hard wired" code. Thanks!