Outlook mail to access

SrPuma

Registered User.
Local time
Yesterday, 22:55
Joined
Jun 17, 2008
Messages
27
hello once again, ive been trying to get the unread mails in the inbox and at the same time unead task items...till now ive come up with this but i dunno if this actualy works since i know nothing about outlook object library :o (the msgbox's are just a experiment since my goal is to pass the mail/task properties to a table and i already have an ideia on that i just need to know how to make the SQL command insert into the table without showing that warning asking yes/no on inserting the new data row like force yes)

For Each Mail In Inbox.Items
If Inbox.DefaultItemType = olTaskItem Then
If task.UnRead = True Then

MsgBox task.Owner
MsgBox task.StartDate
MsgBox task.Subject
MsgBox task.Body
MsgBox task.DueDate
task.UnRead = False
End If
ElseIf Inbox.DefaultItemType = olMailItem Then
If Mail.UnRead = True Then

MsgBox Mail.SenderEmailAddress
MsgBox Mail.SentOn
MsgBox Mail.Subject
MsgBox Mail.Body
MsgBox Mail.SentOn
Mail.UnRead = False
End If
End If
Next
 

Users who are viewing this thread

Back
Top Bottom