0

Hi there,

I am not the bet in Access, I will admit. But need a function to open up a MS Outlook template (.oft file) within Access. Anyone help with quick steps on how to do this, It would be greatly apprciated.

2
Contributors
3
Replies
4
Views
12 Years
Discussion Span
Last Post by Kegtapper
0

You can't.
If you are trying to use Access as a datasource for Outlook you can, but there are limitations. You would have to use Outlook VBA Design controls.

0

Sounds like you are trying to use an ACCESS form to generate OL2000 appointments/etc.

If that is the case you may want to design a form in OUTLOOK modifying an existing template, and pull the data from Access. Then it becomes an Outlook VBA application using automation, events and rules

0

Hi there,

I am not the best in Access, I will admit. But need a function to open up a MS Outlook template (.oft file) within Access. Anyone help with quick steps on how to do this, It would be greatly apprciated.

To answer EXACTLY what you asked - here it is
'---------------------------------------------------
Private Sub Command1_Click()
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItemFromTemplate("C:\Program Files\Microsoft Office\Templates\APPT2.oft")
myItem.Display
End Sub
'--------------------------------------------------
1: Create a Command1 button on ACCESS Form
2: Place Code in EVENT HANDLE

This Code does this
a: Create an OUTLOOK Object
b: Create an Object Item from Template (your existing template in the directory you saved it to.)
c: Displays your item

APPT2 is the name of the custom template, change it to what yours is named


--------Thread End ----------
aka Kegtapper

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.