I have TextBox1 on my Sheet. I have changed few of its properties so
I can write paragraphs in it (see below the properties which I
changed)

EnterKeyBehavior = True
MultiLine = True
ScrollBars = fmSpecialEffectSunken

I got macro which send emails and in that macro I changed the line
..Body = Me.TextBox1.Value
But problem is that when email appears it show all the TextBox1 text
in one line in the email body instead of paragrph. I want text to
appear in email body exactly as it appear or put in TextBox1. Please
can any friend can help that what should I be doing.

On 18 Feb, 13:16, K wrote:

.Body = Me.TextBox1.Value

Try:

.Body = Me.TextBox1.Text


__
Bye!

Scossa

On Feb 18, 1:13*pm, wrote:
On 18 Feb, 13:16, K wrote:

.Body = Me.TextBox1.Value

Try:

*.Body = Me.TextBox1.Text

__
Bye!

Scossa

Thanks it worked

In article <4e8c1054-0b25-4212-af18-b47db1ff43b2
@v13g2000yqm.googlegroups.com,
says...

Thanks it worked


:-)

Tnks for feedback.

--
Bye!

Scossa