Extract Subject,Sent From, Message from mailbox to Excel

[vkarthik21]

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

 

[vkarthik21]

Just bumping the thread. Could someone please help? It is one of
important requirements.

 

[Michael Bauer [MVP - Outlook]]

What is your question?

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 20 Jul 2009 09:12:14 -0400 schrieb vkarthik21:

 

[vkarthik21]

Hi Michael,

How do we extract the following information from a mailbox - Sen
From,
Subject, Date, Message. and put it in a excel sheet by taking th
given
date as the parameter and displaying the required attributes for the
last two days from the given date

Regards,
Karthik

;53248']What is your question?

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 20 Jul 2009 09:12:14 -0400 schrieb vkarthik21:

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 migh 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 - Sen From,
Subject, Date, Message. and put it in a excel sheet by taking th 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 contac system
administrator.

Now the problem here is the system is desiged such a way that fo 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 da 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 t mention
that doing code change is really out of question as the clien doesnt'
want any changes to be done through code currently.

Thanks in Advance.

Regards,
Karthi

 

[Michael Bauer [MVP - Outlook]]

I still don't understand you. However, maybe you want to read data from one
selected email: You can access the MailItem via the ActiveExplorer.Selection
collection.

Please see the object browser (f2) for all the available properties exposed
by the MailItem object: Switch from <All Libraries> to Outlook, then select
MailItem in the left pane.

For working with Excel files, you can add the Excel library to your Outlook
project via Tools/References. Now you can also use the object browser to see
what objects and methods are exposed by Excel: For opening a workbook use
the Workbooks.Open function. And the Range object is used to access a cell
in the workbook and read/write its content (Value property).

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 23 Jul 2009 12:22:22 -0400 schrieb vkarthik21:

Hi Michael,

How do we 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

Regards,
Karthik

;53248']What is your question?

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 20 Jul 2009 09:12:14 -0400 schrieb vkarthik21:

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

 

[Sue Mosher [MVP]]

You might find useful this article, which explains how to search over a date
range: http://www.outlookcode.com/article.aspx?id=30

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54



Am Thu, 23 Jul 2009 12:22:22 -0400 schrieb vkarthik21: