![]() |
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. |
Paragrph in Email Body
On 18 Feb, 13:16, K wrote:
.Body = Me.TextBox1.Value Try: .Body = Me.TextBox1.Text __ Bye! Scossa |
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 |
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