Send outlook-email from Access using template (oft)

F

Filips Benoit

Dear All,

How should i send an outlook-email from access using a template (oft) ?

Thanks
 
S

Sue Mosher [MVP-Outlook]

Write Access VBA code invoking the Application.CreateItemFromTemplate method from the Outlook object model:

Set ol = CreateObject("Outlook.Application")
Set msg = ol.CreateItemFromTemplate("C:\Data\MyTemplate.oft")
msg.Display
' or other code to work with msg
 
Top