SUB folder in outlook inbox

[sal21]

Wouldn't it be easier to select the e-mail in Outlook itself and run a macro to save the attachment?

Hans very, very destroyed!

I have maked a test with:

Set olItm = olFld.Items.Restrict("[ReceivedTime]='07/04/2011 10:19'")

and the code work perfect!

But if i use:

dteLastCheck ="07/04/2011 10:19"

Set olItm = olFld.Items.Restrict("[ReceivedTime]='" & dteLastCheck & "')

the code not found the email!!!!!!!!!!

peraphs is a prob with " ' in the string when encapsuled the var dteLastCheck ????

note:
dteLastCheck is dimensioned Date

[HansV]

Try declaring dteLastCheck as a String instead of a Date.

Or use

Set olItm = olFld.Items.Restrict("[ReceivedTime]='" & Format(dteLastCheck, "dd/mm/yyyy hh:mm") & "'")

[sal21]

Sorry, I don't know how to search for the subject of an e-mail.

About this:

criteria = "@SQL=" & Chr(34) _
& "urn:schemas:httpmail:subject" & Chr(34) _
& " like '%test%'"
Set olItm = olFld.Items.Restrict(criteria)

for shearing

http://msdn.microsoft.com/en-us/library ... 12%29.aspx

[HansV]

Thanks!