![]() |
Follow up Flag Error
I originally submitted the below....
************************************************** ********** A Don" wrote: Hi there, I have been asked to develop a custom form (Outlook 2003) which requires a follow up flag to be generated 1 hour after it is received by the recipient. I have managed to trigger the flag automtically using the following code in the Send Mail function however this only flags up as soon as the mail is opened. Function Item_Send() 'validate the fields before sending Item_Send = False if DoValidation Then 'set the importance & flag Importance = 2 FlagStatus = 2 FlagRequest = "Follow Up " & Item.Subject FlagDueBy = Now() Item_Send = True Else Exit Function End If End Function Reading other forums it is apparent that this is possible using the DateAdd() function, however I'm not too sure how this works. Does anyone out there have any ideas ? Post 2 I think I've cracked it - I've changed 1 line of code FlagDueBy = DateAdd("n",60, Now) ************************************************** ******** I now have an issue with users still using Outlook 2000 - When they populate the form and go to send it a message appears 'The date & time on the follow-up flag for this message have passed. Do you still want to send it?' When yes is selected the mail is sent as normal, and the flag is picked up fine in the recipients mailbox So the code is working as it should. Does anyone know what might be causing this..it works fine in Outlook 2003 and produces no prompt. Thanks |
Follow up Flag Error
Outlook 2000 and 2003 simply handle message flags differently.
-- 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 "A Don" wrote in message ... I originally submitted the below.... ************************************************** ********** A Don" wrote: Hi there, I have been asked to develop a custom form (Outlook 2003) which requires a follow up flag to be generated 1 hour after it is received by the recipient. I have managed to trigger the flag automtically using the following code in the Send Mail function however this only flags up as soon as the mail is opened. Function Item_Send() 'validate the fields before sending Item_Send = False if DoValidation Then 'set the importance & flag Importance = 2 FlagStatus = 2 FlagRequest = "Follow Up " & Item.Subject FlagDueBy = Now() Item_Send = True Else Exit Function End If End Function Reading other forums it is apparent that this is possible using the DateAdd() function, however I'm not too sure how this works. Does anyone out there have any ideas ? Post 2 I think I've cracked it - I've changed 1 line of code FlagDueBy = DateAdd("n",60, Now) ************************************************** ******** I now have an issue with users still using Outlook 2000 - When they populate the form and go to send it a message appears 'The date & time on the follow-up flag for this message have passed. Do you still want to send it?' When yes is selected the mail is sent as normal, and the flag is picked up fine in the recipients mailbox So the code is working as it should. Does anyone know what might be causing this..it works fine in Outlook 2003 and produces no prompt. Thanks |
Follow up Flag Error
So is there a work around for this Sue or is it one of these Microsoft things
we just have to live with? thanks -- M. Paton Support Analyst "Sue Mosher [MVP-Outlook]" wrote: Outlook 2000 and 2003 simply handle message flags differently. -- 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 "A Don" wrote in message ... I originally submitted the below.... ************************************************** ********** A Don" wrote: Hi there, I have been asked to develop a custom form (Outlook 2003) which requires a follow up flag to be generated 1 hour after it is received by the recipient. I have managed to trigger the flag automtically using the following code in the Send Mail function however this only flags up as soon as the mail is opened. Function Item_Send() 'validate the fields before sending Item_Send = False if DoValidation Then 'set the importance & flag Importance = 2 FlagStatus = 2 FlagRequest = "Follow Up " & Item.Subject FlagDueBy = Now() Item_Send = True Else Exit Function End If End Function Reading other forums it is apparent that this is possible using the DateAdd() function, however I'm not too sure how this works. Does anyone out there have any ideas ? Post 2 I think I've cracked it - I've changed 1 line of code FlagDueBy = DateAdd("n",60, Now) ************************************************** ******** I now have an issue with users still using Outlook 2000 - When they populate the form and go to send it a message appears 'The date & time on the follow-up flag for this message have passed. Do you still want to send it?' When yes is selected the mail is sent as normal, and the flag is picked up fine in the recipients mailbox So the code is working as it should. Does anyone know what might be causing this..it works fine in Outlook 2003 and produces no prompt. Thanks |
Follow up Flag Error
I think you have to live with it.
-- 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 "Murray" wrote in message ... So is there a work around for this Sue or is it one of these Microsoft things we just have to live with? thanks -- M. Paton Support Analyst "Sue Mosher [MVP-Outlook]" wrote: Outlook 2000 and 2003 simply handle message flags differently. "A Don" wrote in message ... I originally submitted the below.... ************************************************** ********** A Don" wrote: Hi there, I have been asked to develop a custom form (Outlook 2003) which requires a follow up flag to be generated 1 hour after it is received by the recipient. I have managed to trigger the flag automtically using the following code in the Send Mail function however this only flags up as soon as the mail is opened. Function Item_Send() 'validate the fields before sending Item_Send = False if DoValidation Then 'set the importance & flag Importance = 2 FlagStatus = 2 FlagRequest = "Follow Up " & Item.Subject FlagDueBy = Now() Item_Send = True Else Exit Function End If End Function Reading other forums it is apparent that this is possible using the DateAdd() function, however I'm not too sure how this works. Does anyone out there have any ideas ? Post 2 I think I've cracked it - I've changed 1 line of code FlagDueBy = DateAdd("n",60, Now) ************************************************** ******** I now have an issue with users still using Outlook 2000 - When they populate the form and go to send it a message appears 'The date & time on the follow-up flag for this message have passed. Do you still want to send it?' When yes is selected the mail is sent as normal, and the flag is picked up fine in the recipients mailbox So the code is working as it should. Does anyone know what might be causing this..it works fine in Outlook 2003 and produces no prompt. Thanks |
All times are GMT +1. The time now is 08:53 PM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com