Extract Subject,Sent From, Message from mailbox to Excel

Status
Not open for further replies.
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
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
What is your question?

Best regards

Michael Bauer

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
 
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


What is your question?




--


Best regards


Michael Bauer














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
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
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

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
> 'Michael Bauer [MVP - Outlook Wrote:
> > ;53248']What is your question?
>

>> > > Best regards
> > Michael Bauer
>

>>>>>
>
>
>> 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
 
S

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

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
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
R Trying to extract information between two symbols from outlook subject Using Outlook 2
D Need to extract a line from a word attachment, and add it to the subject line Outlook VBA and Custom Forms 3
N Extract Outlook emails to excel Outlook VBA and Custom Forms 2
M Extract all links from Outlook email, send to Excel Using Outlook 2
T Extract Data From Outlook Tasks Using Outlook 0
T Extract Data From Outlook Tasks Using Outlook 0
V extract users of a particular department Outlook VBA and Custom Forms 1
J Outlook 2013 Extract Flag Completed dates to Excel Macro Outlook VBA and Custom Forms 16
S How to extract mail items from multiple folders and shared mailboxes? Outlook VBA and Custom Forms 0
K Extract email address from body and auto-reply outlook Using Outlook 1
K Extract email to excel from a specific sender Outlook VBA and Custom Forms 3
O VBA to extract email (fields and body) to Excel Outlook VBA and Custom Forms 14
P Recover / Extract Rules from standalone PST file creating RWZ file Using Outlook 2
B Extract Dates for Appointment Item in Body of email Outlook VBA and Custom Forms 10
E Extract excel files from outlook Outlook VBA and Custom Forms 2
K extract certain text from an Outlook Email Message Outlook VBA and Custom Forms 2
D VBA Script to extract text matching specific criteria Outlook VBA and Custom Forms 1
M Extract text in existing message body for use in newmail items Using Outlook 17
M HELP--Extract Data from 2003 outlook transfer to excel spreadsheet Using Outlook 1
M VBA Code to extract data from an Outlook Form Using Outlook 0
M Extract attachments with a script Using Outlook 0
M HELP - Can't open outlook... How can I extract my Emails that I had in folders Using Outlook 3
H Extract emails from Outlokk 2007 email body Using Outlook 0
K Extract Global Address List Using Outlook 1
E I am trying to extract the email adress's i have in outlook. These are not saved 'contacts' these are ones from auto fill. When i open up an email, an Using Outlook 1
L How to extract table format of Task Item if its body contains formatted table. Exchange Server Administration 1
D Extract email addresses from inbox in a batch and move them into "bcc" for a mass email campaign Using Outlook 1
M Extract, zip and replace attachement in each message of a pst file Using Outlook 0
R Saving Outlook Email As Text File Extract Outlook VBA and Custom Forms 2
N Programming to extract automatically extract attachments Outlook VBA and Custom Forms 3
S How to extract outlook calendar data. Outlook VBA and Custom Forms 3
? outlook attachment Extract File ??? Outlook VBA and Custom Forms 1
D Extract Data from OST File Using Outlook 2
N How to extract date and time stamp from messsages Outlook VBA and Custom Forms 6
S Automatically extract attachments? Outlook VBA and Custom Forms 1
I How to extract email addresses from TO or CC line of a particular email Outlook VBA and Custom Forms 2
R Disable conversation thread from replying of recipients in the same subject. Please help Using Outlook 0
M Outlook 2013 Script Assistance - Save Opened Link with Subject Added Outlook VBA and Custom Forms 1
C How to rename subject line and forward the email Outlook VBA and Custom Forms 2
B Add Prefix text to Subject Line Using Outlook 1
P [SOLVED] Auto remove [EXTERNAL] from subject Using Outlook 6
M Outlook 2013 Replace Subject with Conversation (a "hidden" value). Outlook VBA and Custom Forms 0
M Convert Subject Line to Internet Header version of Subject Outlook VBA and Custom Forms 10
M Adding Subject to this Link-Saving VBA Outlook VBA and Custom Forms 5
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
M VBA to auto forward message with new subject and body text Outlook VBA and Custom Forms 8
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
B Remove Subject Residual Outlook VBA and Custom Forms 3
F VBA to ensure a code is entered in Subject title Outlook VBA and Custom Forms 1
Similar threads


















































Top