Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code
Go Back  Xtreme Visual Basic Talk > > > Making text in e-mail bold and underline in VB Code


Reply
 
Thread Tools Display Modes
  #1  
Old 07-31-2012, 12:56 PM
egarland3 egarland3 is offline
Newcomer
 
Join Date: Jul 2012
Posts: 1
Default Making text in e-mail bold and underline in VB Code


Hi there,

I'm looking to make the text in the e-mail that is automatically populated from my excel document be bold. I only want part of it to be bolded though. I'm sure this is a very simple task; however, I'm not able to figure it out. I've copied my code below.

Quote:
Sub Mail_with_outlook1()
'For mail code examples visit my mail page at:
'http://www.rondebruin.nl/sendmail.htm
Dim OutApp As Object
Dim OutMail As Object
Dim strto As String, strcc As String, strbcc As String
Dim strsub As String, strbody As String

Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

strto = "ron@something.abc"
strcc = ""
strbcc = ""
strsub = "Customers"
strbody = "Hi Ron" & vbNewLine & vbNewLine & _
"The total Customers of all stores this week is : " & Cells(FormulaCell.Row, "B").Value & _
vbNewLine & vbNewLine & "Good job"

With OutMail
.To = strto
.CC = strcc
.BCC = strbcc
.Subject = strsub
.Body = strbody
'You can add a file to the mail like this
'.Attachments.Add ("C:\test.txt")
.Display ' or use .Send
End With

Set OutMail = Nothing
Set OutApp = Nothing
End Sub
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code
 
Making text in e-mail bold and underline in VB Code
Making text in e-mail bold and underline in VB Code
 
-->