Userform HTML email format help needed please

Hello all

I have a userform which sends the form entries via email, I have it working fine when sending as Plain text however I want to send in HTML and I'm struggling with the code to enter line breaks etc

This is an extract of the code for the email body which I need to format to work with HTML. Currently it populates the form entries to email however I can't add line breaks as needed

Please Login or Register  to view this content.

Does anyone know how I would write the code so I have OrderIT Reference : iOrderIt, then a line break, with Customer : iCustomer on the next line?

I'm very much a VBA novice so any help would be greatly appreciated

Many thanks in advance

Twaddy

Hi HaHoBe

Thanks very much for your quick reply, worked a treat...so simple, I'd tried <br> but didn't realise I needed the quotation marks too

Do you know how I would also set the font to Ariel and size 10 as it's currently defaulting to Times Roman size 12?

Many thanks

Twaddy

Hi

Thanks very much, had a play about and got it looking like I need

One last question seen as you seem to have all the answers right now...

I've used Application.SendKeys "%s" on a previous macro to auto accept the Outlook security warning and send the email, do you know if this can be adapted to bypass the warning message but then display the email rather than send? Users on occasion will need to add attachments or change the recipients so I want the email to be visible before the user manually sends.

Currently my code is written as...

Please Login or Register  to view this content.

This is to allow the Outlook auto signature to populate on the email of whoever is using the form before adding the text from the user form, the problem being I receive a warning message initially before the email loads with the signature, and then another warning message before the user form text populates in the body of the email

Any thoughts?

Thanks again

Twaddy

Thanks very much, I'll have a read and see if it will work for me. My VBA knowledge is basic at best so most of what I'm doing is trial error, often lots or error

Do you know whether the first option on the linked page will add the signature of whoever uses the form? I can't see reference to naming the signature on the first example as it does on the 2nd so I'm guessing it would

Thanks

Thanks for all your help today HaHoBe, really is appreciated