View previous topic :: View next topic |
Author |
Message |
franke Master Poster
Joined: 26 Jun 2004 Posts: 161 Location: Indiana, USA
|
Posted: Thu May 05, 2011 10:37 am Post subject: Send an Outlook e-mail from Access using a template (oft) |
|
|
How can I send an Outlook e-mail from Access using a template (oft) ? _________________ --------------------------
Thanks for everything. |
|
Back to top |
|
|
neonasafluni New Member
Joined: 03 Feb 2007 Posts: 5 Location: West Bend, WI
|
Posted: Thu May 05, 2011 10:39 am Post subject: |
|
|
Write Access VBA code invoking the Application.CreateItemFromTemplate method from the Outlook object model:
Code: |
Set ol = CreateObject("Outlook.Application")
Set msg = ol.CreateItemFromTemplate("C:\Data\MyTemplate.oft" )
msg.Display
' or other code to work with msg
|
That should get you started. There is other code on this forum (I think) to process the e-mail further. |
|
Back to top |
|
|
|