Hello All,

I am currently working on sheet that i need to have print out user names and random passwords for as many people that entered on the sheet to a text file for email.
I am running into a few issues.
1. When i try to print to a .txt file of the text from column G on sheet 'Review and Generate', all the text appears on one line. I have been trying to use the Char(10) to create line spaces, but that has not worked out for me.
2. I have a random password function running on column F, however i am trying to get it only produce one result and not keep calculating random values.

Attached is the sheet i am working with. Any suggestions and assistance would be much apprenticed!
Maybel password generator..xlsm

Thanks!