![]() |
| 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. |
|
|||||||
| Tags: date, line, predefined, subject |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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 |
| Ads |
|
#2
|
|||
|
|||
|
Is this for internal use only, in an Exchange environment?
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "dries" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
yes it is! exchange on a win SBS 2003
"Sue Mosher [MVP-Outlook]" wrote: Is this for internal use only, in an Exchange environment? -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "dries" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "dries" wrote in message ... yes it is! exchange on a win SBS 2003 "Sue Mosher [MVP-Outlook]" wrote: Is this for internal use only, in an Exchange environment? "dries" wrote in message ... 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 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Subject Line? | Lime | Outlook - Using Forms | 12 | December 7th 06 04:45 AM |
| Subject Line? | Lime | Outlook - General Queries | 1 | December 6th 06 07:47 PM |
| Subject line | Peter | Outlook Express | 1 | May 21st 06 11:10 AM |
| Out of office Subject Line | Outlook - General Queries | 3 | May 10th 06 02:04 PM | |
| lost subject line | Tony Iorio | Outlook - General Queries | 1 | January 18th 06 12:56 PM |