Get details of sent items with Access VBA

[Fritz]

I have an access program that sends emails with Outlook.
I need to get details from each email that was sent today.
I I am looking for VBA code to do the following. From there on I can do the rest.

I want to say:
For each message in outlook.sentmail
TimeSent =
EmailAddress =
Subject =
AttachmentName =
Debug.Print TimeSent, EmailAddress, Subject, AttachmentName
Next message

Can you help me please

 

[Diane Poremsky]

That's not hard. you need outlook's senton, to, subject - attachment name is from the attachment collection so it needs an extra line. I have samples of all both here and at slipstick.com

Debug.Print item.sento item.subject item.to

If Item.Attachments.Count > 0 Then
For Each oAtt In Item.Attachments
Debug.Print oAtt.Name
Next oAtt
end if