Recent content by Roland Askew

  1. R

    Class Modules and WithEvents

    Hi Diane Thanks for your response. Tried what you suggested and also looked at the Microsoft Items.ItemAdd event (Outlook) webpage and managed to rewrite the code to work with these suggestions. Thanks again. Roland
  2. R

    Class Modules and WithEvents

    Any help with this would be really appreciated. I have set up a class module and have it monitoring the default task folder. The module intialize but the event does not ever fire. The code is as follows: I am using Outlook 2021. Public Sub Application_Startup() Set FolderT = New...
  3. R

    VBScript Commands

    Thanks Diane for your help. I will look at doing it the way suggested. Regards Roland
  4. R

    VBScript Commands

    Hopefully someone can point me in the right direction I have a custom form with a command button and I want to program the click function to search the task folder and find other related tasks. I looked all over for any information on this and if anyone can confirm what the VBScript command...
  5. R

    Custom Contact Form how to update when loaded.

    Hi Diane Thank you for taking the time to help me with this due to ease I have gone with updating the Opening event on the form with code that checks the field as follows Function Item_Open() If Item.Birthday = #1/1/4501# Then Item.UserProperties.item("Age Client") = 0 Else If Date() >=...
  6. R

    Custom Contact Form how to update when loaded.

    Thank you for the two replies. I am using a custom field with a formula and I have the field to update automatically. The problem is that it does not automatically update when the form is loaded. Is the update automatically suppose to run when the form is opened? However, as soon as I change...
  7. R

    Custom Contact Form how to update when loaded.

    I have created a custom contact form which calculated the contact age based on their date of birth. The age is stored in a user defined field and I use the normal date of birth field. All this works perfectly when creating the contact the problem is when you open the contact later the age field...
  8. R

    Outlook 2016 wordeditor

    I have got three other scripts to work just having some problems with this one. I am trying to create an email from a task and taking some of the details from the task. I would also like to create hyperlink within the email for the receiving person to be able to open the task. We share the same...
  9. R

    Outlook 2016 wordeditor

    Thank you Diane for your help I have managed to get it to work once I had the confident that it would. Do you know of any good help with using the editor that I could read up on. Thanks again for all your help. Roland
  10. R

    Outlook 2016 wordeditor

    I am trying to use the word editor within a task object. It allows me to use it to add text but when I try to use the selection move command it does nothing. Does anyone know if the word editor works in the body of a task object now. If so can you point me in the directions of where the move...
  11. R

    User Defined Fields adding new value

    Thanks I got it working now.
  12. R

    User Defined Fields adding new value

    I am trying to work out the vba code to amend a User Defined Field. I have created the field in the folder view and want to create a macro to change the field value. Any help would be much appreciated.
  13. R

    How to search for blank userproperties field

    It got this information from a posting by Ken Slovak and apparently the "@SQL" has to be used with DASL syntax property tags. Roland
  14. R

    How to search for blank userproperties field

    Thank Michael for taking the time to answer my question. In case anyone is interested I did manage to solve my problem by creating the strWhere using the @sql statement. The new statement now is as follows and finds all the task that have an entry in the userproperties "project" field...
  15. R

    How to search for blank userproperties field

    I am trying to search through my task that have a userproperties field "Project". I want to loop through all the tasks that have an entry and ignore the task where the field is blank. I have not been able to work out how to search is not blank. So far I have the following code which finds the...
Back
Top