change font styles when sending emails

ashley1

Registered User.
Local time
Today, 04:29
Joined
Apr 7, 2005
Messages
35
Hi

Below is my code to send emails
What i want to do is change font styles
Is it a possible to get strEmail2 bold?
also how would you get text to change font size/colour?

Code:
Dim rsEmail As DAO.Recordset
Dim strCustomerNo As String
Dim strCustomerName As String
Dim strEmail1 As String
Dim strEmail2 As String
Dim strEmail3 As String

strEmail1 = "Dear"
strEmail2 = "'Win a pair of tickets"
strEmail3 = "We are delighted to announce that we have a pair of VIP tickets"

Set rsEmail = CurrentDb.OpenRecordset("Email")
Do While Not rsEmail.EOF
strEmail = rsEmail.Fields("email address").Value
strCustomerNo = rsEmail.Fields("Customer Number").Value
strCustomerName = rsEmail.Fields("Customer Name").Value
DoCmd.SendObject , , , strEmail, , , "Win Tickets", "Ref:" & strCustomerNo & vbCrLf & vbCrLf & strEmail1 & " " & strCustomerName & vbCrLf & vbCrLf & strEmail2 & vbCrLf & vbCrLf & strEmail3, False
rsEmail.MoveNext

Loop
Set rsEmail = Nothing
MsgBox "Email(s) have been sent"

Thanks
 

Users who are viewing this thread

Back
Top Bottom