predefined subject line with date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello

i would like to make a form wich has a predefined subject line, such as:
0654-20070205-subject

the first item is a document-number (to define by user or generated from a
list (excel?), the second item is the date of today, the third item is a
subject line wich has to be defined by the user.

i tried some initial value stuff, but i doesn't work at all.

can someone help me?

tnx in advance
dries
 
Is this for internal use only, in an Exchange environment?

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
yes it is! exchange on a win SBS 2003

Sue Mosher said:
Is this for internal use only, in an Exchange environment?

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Then you'll want to put the code in the form's Item_Open event handler. Create a function to generate the text you want (you know what you want to do -- we don't), then call that function when a new item opens:

Function Item_Open()
If Item.Size = 0 And Item.Subject = "" Then
Item.Subject = YourFunction()
End If
End Function

You can use an InputBox() function to prompt the user for their part and the Month(), Year(), and Day() functions to get you the numeric values from the date.

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

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