View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rivers rivers is offline
external usenet poster
 
Posts: 48
Default Gain senders email address from an email sent to me


is it possible to gain the senders mail address via a command i tried from
and sender but to no avail can anyone help


For Each olMail In Fldr.Items
If InStr(olMail.Body, "") 0 Then
'Or inStr(olMail.Subject, "") 0

str(i) = olMail. ***Senders Email**
i = i + 1
End If
Next olMail