Extracting Senders name and body of message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I go about extracting the senders name and body of email and import
into an access database table?
 
Hi Kerry,

this sample prints the properties of the first Inbox item into the debug
window (strg-g):

Dim oItems as Outlook.MapiFolder
Dim oMail as Outlook.MailItem
Dim obj as Object

Set oItems=Application.Session.GetDefaultFolder(olFolderInbox).Items

If oItems.Count Then
Set obj=oItems(1)
If typeOf obj Is Outlook.MailItem Then
Set oMail=obj
debug.Print oMail.SenderName, oMail.Body
Endif
Endif

Infos for connecting to a database:
http://www.outlookcode.com/d/database.htm
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract specific information from the body of outlook mail to an Excel File using VBA 0
VBA Outlook and Access 2007 1
How to export table from outlook into ms access table? 0
Separate string in email body 3
Extracting CC Email Address Using VBA 2
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Create Auto eMail with Web table Content 1
Bypass security popups when reading mail OL2003 3

Back
Top