ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Paragrph in Email Body (https://www.excelbanter.com/excel-programming/424296-paragrph-email-body.html)

K[_2_]

Paragrph in Email Body
 
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.

[email protected]

Paragrph in Email Body
 
On 18 Feb, 13:16, K wrote:

.Body = Me.TextBox1.Value


Try:

.Body = Me.TextBox1.Text


__
Bye!

Scossa

K[_2_]

Paragrph in Email Body
 
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

Scossa[_2_]

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

Thanks it worked


:-)

Tnks for feedback.

--
Bye!

Scossa


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com