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

[willchum81]

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]

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]

That is right Mr. ansentry.......

 

[willchum81]

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!