Saving an email in an Access Database-2

30 pts.
Tags:
Development
Microsoft 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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Melakeside
    Let us know if you can figure this out! We have been trying to send and save in Access Groupwise emails. Thank you!
    0 pointsBadges:
    report
  • FvdPmcp
    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
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following