Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   View EMail from MS Access Database (http://www.outlookbanter.com/outlook-vba/93517-view-email-ms-access-database.html)

Peter Hibbs August 7th 09 07:38 PM

View EMail from MS Access Database
 
Using Access 2003 & Outlook 2003.

After having received one or more emails in Outlook, is there any way
I can view a specific email from within the Access database, perhaps
using a Hyperlink field or VBA code. I can write some code to copy the
contents of emails into Access but I don't think this would work for
emails that contain images, HTML formatted code, etc.

Is this even possible, is there some sort of 'view' facility in
Outlook that doesn't require Outlook to be loaded.

TIA

Peter Hibbs.

Ken Slovak - [MVP - Outlook] August 7th 09 08:26 PM

View EMail from MS Access Database
 
To view an Outlook item you need to open Outlook.

If you store all the data from an Outlook item in a database table then you
can use an Access form you design to display the stored data, otherwise no
matter what you try you need to use Outlook to display Outlook items.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Peter Hibbs" wrote in message
...
Using Access 2003 & Outlook 2003.

After having received one or more emails in Outlook, is there any way
I can view a specific email from within the Access database, perhaps
using a Hyperlink field or VBA code. I can write some code to copy the
contents of emails into Access but I don't think this would work for
emails that contain images, HTML formatted code, etc.

Is this even possible, is there some sort of 'view' facility in
Outlook that doesn't require Outlook to be loaded.

TIA

Peter Hibbs.



Peter Hibbs August 7th 09 09:34 PM

View EMail from MS Access Database
 

Thanks Ken, I suspected as much.

Peter Hibbs.

On Fri, 7 Aug 2009 15:26:56 -0400, "Ken Slovak - [MVP - Outlook]"
wrote:

To view an Outlook item you need to open Outlook.

If you store all the data from an Outlook item in a database table then you
can use an Access form you design to display the stored data, otherwise no
matter what you try you need to use Outlook to display Outlook items.



All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com