How do i store senders e-mail as soon a new mail arrives

  • Thread starter Thread starter Anvoice
  • Start date Start date
A

Anvoice

Gurus,
I am a novice with outlook vba. Need your help to accomplish the following
I want to store (a)sender's e-mail (b)subject (c)senders phone number in an
excel file as soon as a new mail arrives in my inbox.
How can i do this?
The phone number is with in the body of the e-mail, which i need to scan and
parse.

Thanks for your help.

Regards,
anovice
 
a - MailItem.SenderEmailAddress property
b - MailItem.Subject property
c - It is up to you how you parse the message boxy (MailItem.Body)

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
 
Back
Top