VB Code to create email from different outlook templates

[FGuasp]

HELP!
I'm using Access 2010 and Outlook

I'm attempting to create an e-mail from 1 of 5 different email templates located in a folder. (I have the templates as OFT and HTM)
(When I run the following code I get: Object Required on this specific line of code)
===================
Set MyMail = MyOutlook.CreateItemFromTemplate("C:\Users\AC94014 \Desktop\Test\ky.oft")
=================================


Set MyMail = MyOutlook.CreateItemFromTemplate("C:\Users\AC94014 \Desktop\Test\ky.oft")

If strFile <> "" Then

Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)

With MailOutLook
'.BodyFormat = olFormatRichText
.To = Me.CONTACT_EMAIL_ADDRESS
''.cc = ""
''.bcc = ""
.Subject = "Q3 - " & State & " - " & Me.ORG_NAME & " - " & Me.FileName & " - Provider Roster"

' .HTMLBody = letter
.Attachments.Add (strPath & strFile)
'.Send
.Display '
End With
Exit Sub

[PhilOfWalton]

Purely a guess, but try this

 
Set appOutLook = CreateObject("Outlook.Application")
 
Set MyMail = appOutlook.CreateItemFromTemplate("C:\Users\AC94014 \Desktop\Test\ky.oft")
 
If strFile <> "" Then
Set MailOutLook = appOutLook.CreateItem(olMailItem)
 
 

Phil

[FGuasp]

Thank you! I had to do a little tweaking and it worked