|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
May 11th 06, 10:13 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Run Macro when user saves
All,
I have a custom form and I would like to make sure that sertain fields al filled in correctly when the user saves it, how do I do that?? Flemming 
|
|
#2
May 11th 06, 12:26 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Run Macro when user saves
The easiest way is to use the Validation tab on the Properties dialog for the control for each field.
-- 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 "Flemming" wrote in message ... All, I have a custom form and I would like to make sure that sertain fields al filled in correctly when the user saves it, how do I do that?? Flemming
|
|
#3
May 15th 06, 09:44 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Run Macro when user saves
Hey Sue
Thank You for Your reply. But I was wondering if the validation would be possible to do in VB scripting, since my validation is a bit more complex than the validation tab allows. And yes I put this question into another forum as well, since I was unsure if I put this question into the right forum. I hope I did not do something that is not allowed? Kind regards Flemming "Sue Mosher [MVP-Outlook]" wrote: The easiest way is to use the Validation tab on the Properties dialog for the control for each field. -- 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 "Flemming" wrote in message ... All, I have a custom form and I would like to make sure that sertain fields al filled in correctly when the user saves it, how do I do that?? Flemming
|
|
#4
May 15th 06, 12:35 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Run Macro when user saves
Put code in the Item_Send event handler to check the property values (see http://www.outlookcode.com/d/propsyntax.htm). If they aren't what you want them to be, tell the user and set the return value of the function to False:
Function Item_Send() If values are right Then Item_Send = False End If End Function -- 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 "Flemming" wrote in message ... Thank You for Your reply. But I was wondering if the validation would be possible to do in VB scripting, since my validation is a bit more complex than the validation tab allows. "Sue Mosher [MVP-Outlook]" wrote: The easiest way is to use the Validation tab on the Properties dialog for the control for each field. "Flemming" wrote in message ... All, I have a custom form and I would like to make sure that sertain fields al filled in correctly when the user saves it, how do I do that?? Flemming
|
|
#5
May 16th 06, 08:55 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Run Macro when user saves
Hey Sue
Thank You, this was very helpfull! But I still have a problem, why can I not change the "Label" field in a standard Appointment form? Flemming "Sue Mosher [MVP-Outlook]" wrote: Put code in the Item_Send event handler to check the property values (see http://www.outlookcode.com/d/propsyntax.htm). If they aren't what you want them to be, tell the user and set the return value of the function to False: Function Item_Send() If values are right Then Item_Send = False End If End Function -- 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 "Flemming" wrote in message ... Thank You for Your reply. But I was wondering if the validation would be possible to do in VB scripting, since my validation is a bit more complex than the validation tab allows. "Sue Mosher [MVP-Outlook]" wrote: The easiest way is to use the Validation tab on the Properties dialog for the control for each field. "Flemming" wrote in message ... All, I have a custom form and I would like to make sure that sertain fields al filled in correctly when the user saves it, how do I do that?? Flemming
|
|
#6
May 16th 06, 12:26 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Run Macro when user saves
Are you referring to the calendar color labels? I don't understand how that connects with your original question.
-- 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 "Flemming" wrote in message ... Hey Sue Thank You, this was very helpfull! But I still have a problem, why can I not change the "Label" field in a standard Appointment form? Flemming "Sue Mosher [MVP-Outlook]" wrote: Put code in the Item_Send event handler to check the property values (see http://www.outlookcode.com/d/propsyntax.htm). If they aren't what you want them to be, tell the user and set the return value of the function to False: Function Item_Send() If values are right Then Item_Send = False End If End Function "Flemming" wrote in message ... Thank You for Your reply. But I was wondering if the validation would be possible to do in VB scripting, since my validation is a bit more complex than the validation tab allows. "Sue Mosher [MVP-Outlook]" wrote: The easiest way is to use the Validation tab on the Properties dialog for the control for each field. "Flemming" wrote in message ... All, I have a custom form and I would like to make sure that sertain fields al filled in correctly when the user saves it, how do I do that??
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Grab when user saves a form. | Flemming | Outlook and VBA | 1 | May 11th 06 01:49 PM |
| allow me to run macro time initiated | hirosh | Outlook and VBA | 1 | April 1st 06 06:40 AM |
| outlook macro doesn;t run - sub/function not defined | mudshark | Outlook and VBA | 1 | February 6th 06 10:04 PM |
| Where does OutlookExpress 6.0 saves all its user specific settings on W2K Pro? | David F | Outlook Express | 2 | February 1st 06 09:59 AM |
| Outlook 2000 - Button to run Macro then open Database | David C | Outlook and VBA | 1 | January 25th 06 03:44 PM |
Hybrid Mode
