Attaching email messages in access form

[cassey14]

Hi Everyone..

I hope someone help me on this..

Is it possible that we can attach an email messages inside an access form??please help me..

tanx much in advance..

cassey

[George Oro]

You mean like in MsOutlook or Express that if you insert an image it will view on the body? If so, DHTML will do WYSIWYG.


Regards,
George

[cassey14]

You mean like in MsOutlook or Express that if you insert an image it will view on the body? If so, DHTML will do WYSIWYG.


Regards,
George

first tank you for your response...

i think i need to expalin further..i have a form in access and they want to attach the email message on that form?is it possible..outlook and express will do..but how can i save it to database?

[George Oro]

I see...

I can't help you much but try to look here http://www.helenfeddema.com (outlook)

I developed something before that will read the inbox and save the email & body on a memo field but only in MsOutlook.

hth,
George

[nico5038]

You can link a table to an Outlook folder, just chose the link option when defining a new table and Outlook as filetype on the dialog form.
Next you can place a subform on your form to show the messages and use the mouseup event to check for a string being selected from the message body.
If so you can store that in a database field.

Nic;o)

[pks00]

You can easily read the inbox in outlook but then how do you know which email message 2 display?

[cassey14]

ok il explain further..i have a form..Im doing a system customer management system..they accept conserns when an email was arrived..when they add a new record they want to attach the email message itself and then save it to the database..is this possible??

[George Oro]

I believe you cannot attache the email itself. As a workaround maybe this will do:

1) Link the Inbox
2) Add an email address field in your Customer Information
3) Create a query from the Inbox
4) Create a subform or form and bound to the above query
5) Link the Email Address from the customer information to the Inbox email address.
6) Then your subform/form will automatically view the respective emails of each customer.

The problem only I can think of is, you will lose the attachment and message formatting as access converts all to plain text.

HTH,
George

ok il explain further..i have a form..Im doing a system customer management system..they accept conserns when an email was arrived..when they add a new record they want to attach the email message itself and then save it to the database..is this possible??