A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Outlook 2003 custom forms - data picker, populate combo box and workflow



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old September 23rd 07, 11:48 AM posted to microsoft.public.outlook.program_forms
William Hamilton
external usenet poster
 
Posts: 5
Default Outlook 2003 custom forms - data picker, populate combo box and workflow

Hi all,

We have been tasked with automating a few internal office processes with
Outlook 2003. Three main components we are trying to prototype:

1)Adding a date picker to the form to make it easier to select specific
dates. It seems that this control was added to 2007 but can it be done
in 2003?

2)We can add a combo box from the toolbox but want to populate
automagically if possible. From GAL, Contacts in a public folder and
then and external sourse such as an Access for SQL database... possible?

3)Workflow - a number of the forms needed to pass through a range of
people with approriate feedback loops if not approved.
eg: staff - manager - admin - finance
How can this be done?

The people doing this proof of concept work are not developers so may
ask some silly questions. Forms we are working on include:
Leave application, travel request, purchase order request, meeting
request etc

tia

W
Ads
  #2  
Old September 24th 07, 01:29 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Outlook 2003 custom forms - data picker, populate combo box and workflow

1) In versions before Outlook 2007, Outlook has no date picker control available to programmers (which, by the way, is one reason why the first page of the appointment, journal, and task forms is not editable). See http://www.outlookcode.com/article.aspx?id=26 for controls you can add.

2) You'll need to write code to do that, either VBScript code behind the form or code in an Outlook add-in installed on all machines.

3) Any workflow application requires some mechanism for capturing the "state" of the workflow item, i.e. where it is in the process. What happens to it next depends on that state. As with #2, code can be done in VBScript behind the form or in a separate add-in. You also might want to look at the features that Exchange provides for workflow. Exchange development questions are beyond the scope of this site, which is devoted to Outlook client applications. Docs start at http://msdn.microsoft.com/exchange/ with discussions in the microsoft.public.exchange.development newsgroup or on the Web at http://forums.microsoft.com/TechNet/...=838&SiteID=17
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"William Hamilton" wrote in message ...
Hi all,

We have been tasked with automating a few internal office processes with
Outlook 2003. Three main components we are trying to prototype:

1)Adding a date picker to the form to make it easier to select specific
dates. It seems that this control was added to 2007 but can it be done
in 2003?

2)We can add a combo box from the toolbox but want to populate
automagically if possible. From GAL, Contacts in a public folder and
then and external sourse such as an Access for SQL database... possible?

3)Workflow - a number of the forms needed to pass through a range of
people with approriate feedback loops if not approved.
eg: staff - manager - admin - finance
How can this be done?

The people doing this proof of concept work are not developers so may
ask some silly questions. Forms we are working on include:
Leave application, travel request, purchase order request, meeting
request etc


  #3  
Old September 25th 07, 09:33 AM posted to microsoft.public.outlook.program_forms
William Hamilton
external usenet poster
 
Posts: 5
Default Outlook 2003 custom forms - data picker, populate combo box andworkflow

Sue Mosher [MVP-Outlook] wrote:
1) In versions before Outlook 2007, Outlook has no date picker control available to programmers (which, by the way, is one reason why the first page of the appointment, journal, and task forms is not editable). See http://www.outlookcode.com/article.aspx?id=26 for controls you can add.

2) You'll need to write code to do that, either VBScript code behind the form or code in an Outlook add-in installed on all machines.

3) Any workflow application requires some mechanism for capturing the "state" of the workflow item, i.e. where it is in the process. What happens to it next depends on that state. As with #2, code can be done in VBScript behind the form or in a separate add-in. You also might want to look at the features that Exchange provides for workflow. Exchange development questions are beyond the scope of this site, which is devoted to Outlook client applications. Docs start at http://msdn.microsoft.com/exchange/ with discussions in the microsoft.public.exchange.development newsgroup or on the Web at http://forums.microsoft.com/TechNet/...=838&SiteID=17


Thanks Sue, I will read more and post to the Exchange Dev forum.

thanks

W
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate Outlook 2003 Custom Form from Access 2003 Kujp Sucisv Outlook - Using Forms 1 May 21st 07 10:20 PM
Are Outlook Forms the correct approach for a workflow system? Or Infopath/sharepoint maranoa Outlook - General Queries 1 August 10th 06 04:10 PM
Date Picker for Outlook Forms Irene Outlook and VBA 1 June 15th 06 06:09 PM
Populate a combo box Steffkm Outlook - Using Forms 4 March 14th 06 09:28 PM
Can custom form data populate access database jbtempe Outlook - Using Forms 1 January 20th 06 04:02 PM


All times are GMT +1. The time now is 06:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.