G Guest Jan 12, 2005 #1 How would I go about extracting the senders name and body of email and import into an access database table?
How would I go about extracting the senders name and body of email and import into an access database table?
M Michael Bauer Jan 13, 2005 #2 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
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
N nycboy Jan 13, 2005 #3 Hi Kerry, If you need this kind of service, please check out: http://www.evidencehouse.com/
