Display a multi-line text box from User Form in a generated outlook e-mail

I have a User Form that is populated with event information.

One of the fields populates information (Additional Information) in a cell that contains multiple lines of text.

The user can edit this field and when they click "preview" a procedure creates an e-mail in outlook with the event information and edited information.

However the additional information field with multiple lines, when referenced in the body of the e-mail, displays on one line.

I did expect this because to create new lines in the e-mail within vba I have to use html ("<br>") which isn't used nor really can be used by the user in the User Form.

If anyone can think of a way around this (reference this field but have it displayed as multi-lined in the e-mail) it would be very much appreciated.

Hopefully the below part helps in showing what I'm trying to do ("AI" is the field with mulitple lines I'm trying to display in the e-mail as multi lined):

Please Login or Register  to view this content.

thanks for your help, its still displaying the e-mail as one line though

I tried vbnewline and vbcrlf wrote it in like this, is that right?

Please Login or Register  to view this content.

thanks I appreciate your help, unfortunately the outlook message still displays the additional information field all on one line. I'll keep trying

If anyone is looking to a solution to this I have come to the conclusion that there isn't one without the user adding either "<br>" (html) or vbnewline in the User Form field, depending on whether the body of the e-mail is html or not.

The only way around it to have multiple text boxes in the User form for each line, in your code reference each field and add a line break (as above) if field is not blank, any empty fields won't display, any filled in fields will appear with a line break after them.

worked perfectly! many thanks