Keeping break lines from textbox when sending email

**DreamEyes** · 10-21-2014, 05:33 PM

Hello everyone,

There is an issue I can't solve and I'd like your advice on this one.

I have an Excel sheet with a textbox and a "Send" button.
User can put their comments in the textbox and then press "Send" to automatically send an email with the file attached and a generic subject/body line ("Please find attach my comments").

My problem:

In the email's body, I would like to include the content of the textbox, so I don't have to open the file to read the comment.
The thing is, break lines are not included and it looks like a wall of text.

Example:

If I use

strBody = "Hi there,<br><br>" & vbNewLine & "Please find attached my comments" & vbNewLine & "Thanks," & vbNewLine & Comments.commentsdetails

strSubject = "My Comments"

and if the textbox "commentsdetails" contains:

Hello, this is a test.
Thank you for reading my comment.

The email's body will look like this:

Hi there,
Please find attached my comments
Thanks,

Hello, this is a test.Thank you for reading my comment.

instead of

Hi there,
Please find attached my comments
Thanks,

Hello, this is a test.
Thank you for reading my comment.

Is there any way to include all break lines from the textbox in my email's body?

Please let me know if I am unclear or if you need any additional details.

And as always, thank you for your help.

**quekbc** · 10-21-2014, 06:42 PM

How are you extracting the content of the textbox?

I do not have Outlook installed on this system but testing it on MsgBox, Debug.Print and the InStr function tells me that there is a line feed character - Chr(10) or vbLf.

I used

Please Login or Register  to view this content.

to extract the content of the text box.

Hope this helps.

**DreamEyes** · 10-22-2014, 02:16 PM

Hello quekbc,

Thank you very much for your reply.
I'm afraid I'm not sure how I can use your code in this case...

Just to give you more info on how the email is sent (I'll do my best to explain, though it is not my code):

The email body text is in the cell E158, with this VBA code:

Please Login or Register  to view this content.

To send the email with Outlook, a window (form) with the email subject/body is displayed. When pressing the "Send" button, the following code is used:

Please Login or Register  to view this content.

The code may be messy and there are many modules as well, so I hope I'm not too confusing.

I tried again and even if the cell E158 (email's body) contains the following text:

Hello,
This is a test.

The content in the email will be displayed as:

Hello,this is a test.

**DreamEyes** · 10-22-2014, 05:16 PM

Sorry for the double post.

Quekbc's post gave me an idea and I realise that there was an easy solution.

The cell E158 contains the email's body text.
I just used the cell H158 with the formula

Formula:

Please Login or Register  to view this content.

This replaces break lines with <br> since the email actualy uses html codes (I didn't think of that).
So now, the email's body looks fine.

I edited the thread title with [SOLVED]. I'll come back here if it turns out that my solution doesn't work.
I hope this can help someone facing the same issues someday.