Originally posted by adzzzz
that gives me a type mismatch m8
Sorry, I keep forgetting that vbCrLf is the actual character(s), not the number . Try replacing vbCrLf with vbKeyReturn.