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