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

comparing and subtracting sent and received dates



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old September 29th 09, 10:03 PM posted to microsoft.public.outlook.program_vba
Tom in Tunis
external usenet poster
 
Posts: 1
Default comparing and subtracting sent and received dates

I'm not a programmer and am looking for some help to solve a relatively
simple task. We are using Outlook 2003 but will eventually migrate toOutlook
2007 I expect. There are about 50 email requests per day. Let me explain the
process.

Group A receives an email with a request from User Group. Group A forwards
the email with the request to Group B. Then Group B sends the email to Group
C, which is copied to the User Group.

I am going to be copied at each stage of the process. I wish to keep track
of the following: (1) duration of time (days + hours) that Group A keeps the
email received by User Group before sending it to Group B, (2) duration of
time (days + hours) that Group B keeps the email before sending it to Group C
(which is cc'd to User Group). Each email received by Group A has a unique
subject line, but the subject line changes when Group A forwards the email to
Group B. The subject line of the email received by Group B is re-used by
Group B when sending the email to Group C. User Group is complaining that
there is too much delay in the processing. User Group only sees the date of
their email request enters and the date their request is satisfied. For each
email request, I wish to be able to have enough info to know where the delays
occur.

Thanks for any assistance.


Ads
  #2  
Old September 29th 09, 10:26 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP][_3_]
external usenet poster
 
Posts: 465
Default comparing and subtracting sent and received dates

So, just what kind of help are you looking for? Confirmation that this is
feasible? (Can't say at this point, without knowing what information might
be available to correlate the messages received by Group A with those
received by Group B.) Someone to write code for you?
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Tom in Tunis" Tom in wrote in message
...
I'm not a programmer and am looking for some help to solve a relatively
simple task. We are using Outlook 2003 but will eventually migrate
toOutlook
2007 I expect. There are about 50 email requests per day. Let me explain
the
process.

Group A receives an email with a request from User Group. Group A forwards
the email with the request to Group B. Then Group B sends the email to
Group
C, which is copied to the User Group.

I am going to be copied at each stage of the process. I wish to keep track
of the following: (1) duration of time (days + hours) that Group A keeps
the
email received by User Group before sending it to Group B, (2) duration of
time (days + hours) that Group B keeps the email before sending it to
Group C
(which is cc'd to User Group). Each email received by Group A has a unique
subject line, but the subject line changes when Group A forwards the email
to
Group B. The subject line of the email received by Group B is re-used by
Group B when sending the email to Group C. User Group is complaining that
there is too much delay in the processing. User Group only sees the date
of
their email request enters and the date their request is satisfied. For
each
email request, I wish to be able to have enough info to know where the
delays
occur.

Thanks for any assistance.




  #3  
Old September 30th 09, 09:36 AM posted to microsoft.public.outlook.program_vba
Tom in Tunis[_2_]
external usenet poster
 
Posts: 1
Default comparing and subtracting sent and received dates

I'd be interested to know what conditions are needed to be met in order to
make it feasible. I should add that there is an attachment to the originating
email from User Group that is processed and then sent by Group A to B to C.

The subtraction of dates from emails in two separate Outlook folders I
expect is straight forward. The common identifier could be the subject, when
Group A sends the email and attachment to Group B, and Group B forwards on to
Group C. I am cc'd on both messages and put these messages in separate
folders.

But when the the subject line is changed by Group A from what User Group
used as a subject line, then I wonder how easy it is to track the email and
attachment through the subsequent processing steps.

As to writing the code to do the job, that is the next step. I do need
someone to write the code.

Thanks.



"Sue Mosher [MVP]" wrote:

So, just what kind of help are you looking for? Confirmation that this is
feasible? (Can't say at this point, without knowing what information might
be available to correlate the messages received by Group A with those
received by Group B.) Someone to write code for you?
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Tom in Tunis" Tom in wrote in message
...
I'm not a programmer and am looking for some help to solve a relatively
simple task. We are using Outlook 2003 but will eventually migrate
toOutlook
2007 I expect. There are about 50 email requests per day. Let me explain
the
process.

Group A receives an email with a request from User Group. Group A forwards
the email with the request to Group B. Then Group B sends the email to
Group
C, which is copied to the User Group.

I am going to be copied at each stage of the process. I wish to keep track
of the following: (1) duration of time (days + hours) that Group A keeps
the
email received by User Group before sending it to Group B, (2) duration of
time (days + hours) that Group B keeps the email before sending it to
Group C
(which is cc'd to User Group). Each email received by Group A has a unique
subject line, but the subject line changes when Group A forwards the email
to
Group B. The subject line of the email received by Group B is re-used by
Group B when sending the email to Group C. User Group is complaining that
there is too much delay in the processing. User Group only sees the date
of
their email request enters and the date their request is satisfied. For
each
email request, I wish to be able to have enough info to know where the
delays
occur.

Thanks for any assistance.





  #4  
Old September 30th 09, 01:45 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP][_3_]
external usenet poster
 
Posts: 465
Default comparing and subtracting sent and received dates

You would need some way of matching up the messages sent at each stage. If
the subject changes, it's not going to be useful for that purpose.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Tom in Tunis" wrote in message
...
I'd be interested to know what conditions are needed to be met in order to
make it feasible. I should add that there is an attachment to the
originating
email from User Group that is processed and then sent by Group A to B to
C.

The subtraction of dates from emails in two separate Outlook folders I
expect is straight forward. The common identifier could be the subject,
when
Group A sends the email and attachment to Group B, and Group B forwards on
to
Group C. I am cc'd on both messages and put these messages in separate
folders.

But when the the subject line is changed by Group A from what User Group
used as a subject line, then I wonder how easy it is to track the email
and
attachment through the subsequent processing steps.

As to writing the code to do the job, that is the next step. I do need
someone to write the code.

Thanks.



"Sue Mosher [MVP]" wrote:

So, just what kind of help are you looking for? Confirmation that this is
feasible? (Can't say at this point, without knowing what information
might
be available to correlate the messages received by Group A with those
received by Group B.) Someone to write code for you?
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Tom in Tunis" Tom in wrote in message
...
I'm not a programmer and am looking for some help to solve a relatively
simple task. We are using Outlook 2003 but will eventually migrate
toOutlook
2007 I expect. There are about 50 email requests per day. Let me
explain
the
process.

Group A receives an email with a request from User Group. Group A
forwards
the email with the request to Group B. Then Group B sends the email to
Group
C, which is copied to the User Group.

I am going to be copied at each stage of the process. I wish to keep
track
of the following: (1) duration of time (days + hours) that Group A
keeps
the
email received by User Group before sending it to Group B, (2) duration
of
time (days + hours) that Group B keeps the email before sending it to
Group C
(which is cc'd to User Group). Each email received by Group A has a
unique
subject line, but the subject line changes when Group A forwards the
email
to
Group B. The subject line of the email received by Group B is re-used
by
Group B when sending the email to Group C. User Group is complaining
that
there is too much delay in the processing. User Group only sees the
date
of
their email request enters and the date their request is satisfied. For
each
email request, I wish to be able to have enough info to know where the
delays
occur.

Thanks for any assistance.







 




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
Comparing contacts baz3178 Outlook - Using Contacts 3 February 6th 08 01:24 PM
i want 2 know Storing of resume in database and comparing it with the other sriram Outlook - Using Contacts 1 September 11th 07 01:32 PM
Imported messages: received vs. created dates JBW Outlook - General Queries 2 January 16th 07 04:32 PM
Fix received dates on items after importing from Outlook Express John Bresnahan Outlook and VBA 1 September 25th 06 10:24 PM
Comparing 2 MSG files . peketi Outlook and VBA 7 February 17th 06 05:51 AM


All times are GMT +1. The time now is 01:55 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-2025 Outlook Banter.
The comments are property of their posters.