Ms Access and Ms Outlook (is there a way to link them?) (1 Viewer)

W

willchum81

Guest
Hello,

Is there a way in Access to create a database that stores (a list of) Ms Outlook emails? And then, is there a way I could drag and drop an email from Outlook into the access database?

Thanks...

Willchum.
 

ansentry

Access amateur
Local time
Today, 20:58
Joined
Jun 1, 2003
Messages
995
Open you Access db, go to Tables/ File/Get External Data/ Link Tables.

When the dialog box opens Under "File of Type" select Outlook(). You will see a dialog box appear, choose what you wish and give it a try.

Hope this helps.
 

ocp&mcsd

The Hitman
Local time
Today, 02:58
Joined
Jan 25, 2006
Messages
113
That is right Mr. ansentry.......
 
W

willchum81

Guest
This is excellent stuff... Thanks heaps guys.. This has just opened up a whole world of possibilities for me!

Is there a way I can preserve the format of the email? (ie, HTML, Plaint Text, Rich Text, any attachments it may have?)

Thanks!
 

Users who are viewing this thread

Top Bottom