Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / January 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Anvoice - 25 Jan 2008 04:12 GMT
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
Dmitry Streblechenko - 25 Jan 2008 17:38 GMT
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

> Gurus,
> I am a novice with outlook vba. Need your help to accomplish the following
[quoted text clipped - 10 lines]
> Regards,
> anovice
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.