Selecting a template to email using Access 2007

[michaeljohnh]

I am using a form to select an email address and Outlook template to email. I am able to get the new email to open in Outlook with the proper address without a problem (found the code in another post here). I cant seem to figure out how to adjust the code to use a pre-existing Outlook email template. The control Im using is cboTemplate. Here is the code:


On Error GoTo Err_Command39_Click
Dim stDocName As String
stDocName = "Empty_Report"
' DoCmd.SendObject acReport, stDocName
DoCmd.SendObject acSendNoObject, stDocName, acFormatXLS, Me.email_recipient, , , "Test Email", , True
Exit_Command39_Click:
Exit Sub


Err_Command39_Click:
MsgBox Err.Description
Resume Exit_Command39_Click


One final note, I am required to use Outlook.
Thanks in advance!

[pbaldy]

Though I haven't used it, the final argument of SendObject is for a template. From help:

A string expression that's the full name, including the path, of the file you want to use as a template for an HTML file.

[michaeljohnh]

I gave that a try and though it didnt generate an error, it also didnt seem to have any affect on the email. I put the entire path and file name in quotes at the end. Im wondering if maybe the .oft format isnt supported. Im heading home now, Ill try different formats tommorrow. If someone can make a working example and post it that would be great.

[michaeljohnh]

Well I tried using a .txt file with the typical html tags as well at an .htm file and neither work. I suspect the functionality of that argument is different than what I am looking for. Or the formatting of the body of the file is extremely particular.