getting the subject line out of a mail

C

capri_corn_ripe

Hi,

I am using following code to get time stamp and subject of a mail item

Sub TimeStampDigger()

Dim i%, myItem As Outlook.MailItem, excelApp As Object, excelBook
As Object

Set myItem =
Application.Session.GetDefaultFolder(olFolderInbox).Items(1)
myTime = myItem.ReceivedTime

Set excelApp = CreateObject("Excel.Application")
Set excelBook = excelApp.Workbooks
excelBook.Open ("C:\Documents and Settings\n.bansal\Desktop\Report
Delivery Performance")

End Sub

I am getting problems in getting the subject item.

Kindly help.

Regards,
Nitesh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

getting the subject line out of a mail 2
Want to forward a template email with an email address contained inthe trigger email 1
Move email using the Close event 11
select ALL option 2
Access Program Only Looping Part Way Through Outlook Inbox 2
trap outbound mail to update subject 6
Changing the subject line of a message to a set format 3
how to disable security message in save attachments macro "A programis trying to access e-mail addre 5

Top