vkarthik21
Member
Hi All,
First of all am not sure if this is the right forum for this posting and as a programmer I thought maybe programmatically my issue might be resolved hence the posting.
Here is the requirement. We would like to either create/add a add-in that will extract the following information from a mailbox - Sent From, Subject, Date, Message. and put it in a excel sheet by taking the given date as the parameter and displaying the required attributes for the last two days from the given date.
In one of our appilcations recently upgraded we have serveral SQL Server Jobs running and sending out mails from a mailbox server. These mails are composed of a particular format i.e.
1. Subject line -Interface execution Report - <Interface Name>
2. Message - <Interface Name> has been successful. Attached is the message, or
(in case of failure) <Interface Name> has failed. Please contact system administrator.
Now the problem here is the system is desiged such a way that for both the scenarios it sends out the mail with the subject line and the message may vary. And it is upon us to manually open the message and check for the cause of failure. Now in order to avoid this we are looking at having a program/add-in that when run for the given day gives us the pertinet details in the excel sheet for the span of 2 days to know the working of the interfaces.
Is there a better way of handling this issue? Please let us know. And the outlook version is Outlook Office 2003. Also I would like to mention that doing code change is really out of question as the client doesnt' want any changes to be done through code currently.
Thanks in Advance.
Regards,
Karthik
First of all am not sure if this is the right forum for this posting and as a programmer I thought maybe programmatically my issue might be resolved hence the posting.
Here is the requirement. We would like to either create/add a add-in that will extract the following information from a mailbox - Sent From, Subject, Date, Message. and put it in a excel sheet by taking the given date as the parameter and displaying the required attributes for the last two days from the given date.
In one of our appilcations recently upgraded we have serveral SQL Server Jobs running and sending out mails from a mailbox server. These mails are composed of a particular format i.e.
1. Subject line -Interface execution Report - <Interface Name>
2. Message - <Interface Name> has been successful. Attached is the message, or
(in case of failure) <Interface Name> has failed. Please contact system administrator.
Now the problem here is the system is desiged such a way that for both the scenarios it sends out the mail with the subject line and the message may vary. And it is upon us to manually open the message and check for the cause of failure. Now in order to avoid this we are looking at having a program/add-in that when run for the given day gives us the pertinet details in the excel sheet for the span of 2 days to know the working of the interfaces.
Is there a better way of handling this issue? Please let us know. And the outlook version is Outlook Office 2003. Also I would like to mention that doing code change is really out of question as the client doesnt' want any changes to be done through code currently.
Thanks in Advance.
Regards,
Karthik