Reference First name in email heading
Posted on 2013-01-29
I have an email button that is working properly. I would like it to start referencing the clients first name in the heading. Below is some of the code. Instead of saying "<HTML>Dear Big Arms Swimmers Client,<BR><BR><BR>" . I'd like it to say "Dear <CLIENTFIRSTNAME>
How would I reference that information in the form?
Private Sub Command108_Click()
Dim objOutlook As Object, objEmailMessage As Object
Dim sSubj As String, sBody As String
sSubj = "Swim Lesson Policy at Coto Valley Country Club"
sBody = "<HTML>Dear Big Arms Swimmers Client,<BR><BR><BR>" _
& "<P>Thanks for signing up for swim lessons at Coto Valley Country Club, " _
& "we are sure you are going to enjoy your experience at one of the premier country clubs " _
& "in the area. Your purchase of swim lesson will allow your child the opportunity use " _
& "the pool during the allotted swim lessons time.</P><BR>The country club is designed to " _
& "be very affordable option for local families (both in and outside of the gates " _