Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Forms (http://www.outlookbanter.com/outlook-using-forms/)
-   -   Follow up Flag Error (http://www.outlookbanter.com/outlook-using-forms/13613-follow-up-flag-error.html)

A Don May 3rd 06 04:31 PM

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



Sue Mosher [MVP-Outlook] May 3rd 06 07:38 PM

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



Murray May 4th 06 10:56 AM

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




Sue Mosher [MVP-Outlook] May 4th 06 01:14 PM

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