OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Saving Mails received in outlook to Access as an object

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion
View previous topic :: View next topic  
Author Message
kbsudhir
Newbie
Newbie


Joined: 03 Jan 2008
Posts: 1
Location: India

PostPosted: Fri Jan 04, 2008 12:27 pm    Post subject: Saving Mails received in outlook to Access as an object Reply with quote

I am trying to save the mails I receive in my outlook to my access database (Iam Using Outlook 2003 and access 2003). I am able to capture all the attributes of the mail as body, subject, to, from , importance but I have to save the whole of the mail as on object.

I have created a table with field "OLE OBJECT" as the datatype. Right Now I have first save the mail manually to a physical location and then , click on the field in the database and manually insert the mail.

1. Click Insert
2. Click Object
3. Select "Create from File"
4. Browse to its location and select the necessay file to be inserted.

Is there any way to automate this so that we can directly insert teh mail to the access as an object.

Any help in this regard is appreciated.

Shocked
_________________
Thanks
Sudhir
Back to top
View user's profile Send private message
Corfy
Moderator
Moderator


Joined: 14 Jun 2005
Posts: 1117
Location: Near Indianapolis, IN, USA

PostPosted: Fri Jan 04, 2008 1:25 pm    Post subject: Reply with quote

You might be able to find some people to help you with this on this forum, but for the most part, this forum is designed to help users of OpenOffice.org, which is an alternative to Microsoft Office. Hence, there may not be too many Microsoft Office users hanging around that can help you with MS Outlook and MS Access. Just letting you know.
_________________
Laugh at life or life will laugh at you.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group