A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

task being updated............



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 10th 06, 03:29 PM posted to microsoft.public.outlook.program_vba
vonClausowitz
external usenet poster
 
Posts: 29
Default task being updated............

Hi All,

I found out that when a task is clicked away as completed that in the
body at the second line there is 12 dashes added, like this:

------------

Now I want to change this. I don't want the dashes added. Is there
anything I can change to prevent this?
The point is that i run a code that checks the dates in my task body
and these line is not a date.
Now I get stuff like:

20060202

------------
20060201
etc...

Marco

  #2  
Old February 10th 06, 08:48 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default task being updated............

Sorry Marco, there's no way to change that behaviour. You're only recourse
is to programmatically modify the changes in the body, but it wouldn't really
be practical in my opinion.

--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"vonClausowitz" wrote:

Hi All,

I found out that when a task is clicked away as completed that in the
body at the second line there is 12 dashes added, like this:

------------

Now I want to change this. I don't want the dashes added. Is there
anything I can change to prevent this?
The point is that i run a code that checks the dates in my task body
and these line is not a date.
Now I get stuff like:

20060202

------------
20060201
etc...

Marco


  #3  
Old February 10th 06, 09:21 PM posted to microsoft.public.outlook.program_vba
vonClausowitz
external usenet poster
 
Posts: 29
Default task being updated............

What if the two lines are added to the body?
Will it keep adding them to it everytime the task is completed or just
once?
If not then I could just leave it in and start filling in my dates at
line three.
Like:

------------
20060202

Marco

  #4  
Old February 10th 06, 09:48 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default task being updated............

If your ultimate goal is to capture the date that assigned Tasks are
completed, monitor the changes in the original Task item itself. This item
has the DataCompleted property in the Object Model; far better than reading
it in the message body of a task update message.

--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"vonClausowitz" wrote:

What if the two lines are added to the body?
Will it keep adding them to it everytime the task is completed or just
once?
If not then I could just leave it in and start filling in my dates at
line three.
Like:

------------
20060202

Marco


  #5  
Old February 11th 06, 09:00 AM posted to microsoft.public.outlook.program_vba
vonClausowitz
external usenet poster
 
Posts: 29
Default task being updated............

You're right....however we need to keep track of changes in the tasks
over the last 14 days. So we need to be able to see on which days the
last 14 days a certain task has been updated and more important on
which days not....

That's why we write the date of the change in the body like this:

Function AddDates(ByVal TaskSubject As String, _
ByVal TaskBody As String, _
ByVal fnYear As String, _
ByVal fnMonth As String, _
ByVal fnDay As String) As String

Dim x As Long
Dim FirstDate As Date
Dim RecordDate As Date
Dim Records() As String

Records = Split(TaskBody, vbCrLf)
For x = 0 To UBound(Records)
'eerst even de eerste twee regels leegmaken
If Records(0) Like "" Then Records(0) = "X\X/X"
If Records(1) Like "------------" Then Records(1) = "X\X/X"
If Records(x) Like "########" Then
RecordDate = Format(Records(x), "@@@@-@@-@@")
If InStr(TaskSubject, "WEEKLY") 0 Then
If DateDiff("d", RecordDate, Date) = 30 Then
Records(x) = "X\X/X"
End If
Else
If DateDiff("d", RecordDate, Date) = 14 Then
Records(x) = "X\X/X"
End If
End If
End If
Next
TaskBody = Join(Records, vbCrLf)
Do While InStr(TaskBody, "X\X/X" & vbCrLf) 0
TaskBody = Replace$(TaskBody, "X\X/X" & vbCrLf, "")
Loop
AddDates = fnYear & fnMonth & fnDay & vbCrLf & TaskBody

End Function

Marco

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Updated from 2002 to 2003. Now Outlook will not open Terry Outlook - Installation 0 February 22nd 06 07:03 AM
How do I keep Contacts updated between different computers? WRG Outlook - Using Contacts 1 January 29th 06 04:17 PM
Removing the word "Updated" from the object of an updated meeting? [email protected] Outlook - General Queries 0 January 25th 06 12:29 PM
Outbox preview pane not updated after editing John Carson Outlook Express 8 January 20th 06 08:09 PM
I updated my Microsoft software now lost all contact info. gary Outlook - Using Contacts 1 January 13th 06 02:18 AM


All times are GMT +1. The time now is 05:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.