ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Gain senders email address from an email sent to me (https://www.excelbanter.com/excel-programming/419662-gain-senders-email-address-email-sent-me.html)

rivers

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

Nigel[_2_]

Gain senders email address from an email sent to me
 
Try posting in the Outlook newsgroup

--

Regards,
Nigel




"Rivers" wrote in message
...

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




All times are GMT +1. The time now is 05:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com