Hi

I am trying to make various buttons in my forms that send out a template email - text is always the same and just takes (firstname)or other details from a candidates record.

See below:
DoCmd.OpenForm "EmailF"
    Forms!EmailF!MsgTo = EmailAddress
    Forms!EmailF!MsgSubject = "Your application " & FirstName
    Forms!EmailF!MsgBody = "Dear " & FirstName & " , We received your application " & _
             "we would like to invite you "  "."

Tried all andcannot figure it out.

The body of each message is like  6/7 lines of text + signature.

Is this the way or is there an easier solution?

Kind regards
Martijn Eisinga

---

Reply from Alex Hedley:

Have you seen Lesson 19?

  19. Bulk Customized Email 5 (36:23)
  Select an Email Template
  Template Table and Form