Outlook form backend

  • Thread starter Thread starter Darobe9926
  • Start date Start date
D

Darobe9926

I'm not sure if I am posting this into the right group or not but I
hope I am.

I am trying to make a custom form that will let me send a training
request to my boss and have all that information stored in a Access
database backend.

In the first place is this even possible? From what I have read so far
it should be. The second thing is I have no experience in programming
VBA so anything would be greatly appreciated. I have some programming
experience but VBA syntax is a little above me.

Thanks,

Dan
 
As a practical matter, you'd be able to get it to work only if you can publish the custom form to the Organizational Forms library on Exchange Server or each user's Personal Forms library. Even if you met those requirements, you would have a steep learning curve ahead of you, since you'd need to learn:

-- VBScript syntax if you plan to put the code to talk to the database behind the custom form (It's not clear whether VBA would be an alternative, given what you've told us so far.)

-- Syntax for working with the Outlook object model

-- ADO syntax for working with the database

Outlook custom message forms are not the best way of performing this kind of operation. A much better tool from the Office 2003 and 2007 suites is InfoPath.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top