Multiply Lines

[kernal88]

Hi

I am trying to create a email using VBA. the issue i am having is I want my msgbody to be on multiply line in my email
see code below

email = Me.E_Mail
dayofparty = Me.Day
dateofparty = Me.Date_of_Party
partytime = Me.Combo28
partytype = Me.Combo32
partybuilding = Me.Venue
partyroom = Me.[Party_ Room]
partygirl = Me.Party_Coordinator

msgbody = "We can't wait to see you on " & dayofparty & ", " & dateofparty & " at " & partytime & " for your " & partytype & " party! Your party room will be at " & partybuilding & " in the " & partyroom & " Room;. Your hostess will be " & partygirl & ". Can't wait to see you there!"


With olMail
.To = email
.Subject = "Party Reminder"
.HtmlBody = msgbody
.Display
End With
Set olMail = Nothing
Set olApp = Nothing


Thank
RK

 

[boblarson]

Using HTML you would need to use the <BR> character where you want the break to occur.

like:

[COLOR=black]msgbody[/COLOR] = "We can't wait to see you on " & dayofparty & ", " & dateofparty & " at " & partytime & " for your " & partytype & " party! 
[B][COLOR=red]<BR>[/COLOR] [/B]Your party room will be at " & partybuilding & " in the " & partyroom & " Room;. 
[B][COLOR=#ff0000]<BR>[/COLOR][/B]Your hostess will be " & partygirl & ". 
[B][COLOR=#ff0000]<BR>[/COLOR][/B]Can't wait to see you there!"

 

[kernal88]

worked great