Home > IT Answers > Exchange > Saving an email in an Access Database-2
Straub
30 pts.
 Saving an email in an Access Database-2
Development, Exchange, Visual Basic
I have a VB6 application that manages tasks. When the status of a tack changes, the program generates an email and sends it thru outlook. I would like to have a table in access to save the emails for the purpose of documentation. Access has a type of object, but when i try to set the field to the MAPIMessage.object I get an error. Is what im trying to do possible and what am I doing wrong? Thanks

Software/Hardware used:
ASKED: October 15, 2004  10:51 AM
UPDATED: October 25, 2004  9:32 AM
RELATED QUESTIONS
Answer Wiki:
Try setting the field in the access table to OLE Object. I've never done this before, but I would use the .save method to save the email as .msg or .txt to a temporary location then insert it into the field programmatically. Here's the rub. I am not sure if you are able to insert the object programmatically. When I have an OLE object as a field (say as an image or text file), it is inserted using the context (right-click) menu from the field itself choosing "insert object." You may be able to use the DoCmd.DoMenuItem to accomplish this programmatically, but again, I'm not sure. Good luck Chris
Last Wiki Answer Submitted:  October 16, 2004  7:45 pm  by  Cafeaulait   0 pts.
All Answer Wiki Contributors:  Cafeaulait   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Let us know if you can figure this out! We have been trying to send and save in Access Groupwise emails.

Thank you!

Melakeside
 0 pts.
 

microsoft:
http://support.microsoft.com/default.aspx?scid=kb;en-us;205635

you would create an OLE object (e.g. OleObj) and use OleObj.CreateEmbed PathToOleObj method

Let me know if this helps.

good luck,

Frans

FvdPmcp
 0 pts.