code for opening an outlook template

[griffin700]

hi,

have a small problem.. trying to build a code in VB (in MS access) where I want:

if value in field A is 1 then it should open a predefined outlook template (template 1 ) stored on for example C:\my_database\templates\

If value in field A is 2 then it should open template 2 from the same location

I´ve got 4 different templates...
any idea how to write the code correctly?

thanks & regards
G

[nico5038]

The basic code can be found at:
http://www.daniweb.com/forums/thread35424.html

The crucial line for you is:
Set myItem = myOlApp.CreateItemFromTemplate("C:\Program Files\Microsoft Office\Templates\APPT2.oft")

The string can be made "dynamic" by using the value from the variable (being 1 to 4) like:

Set myItem = myOlApp.CreateItemFromTemplate("C:\my_database\tem plates\template " & Me.A & ".oft")

Nic;o)