By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,251 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Attaching email messages in access form

P: 43
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
Jan 8 '07 #1
Share this Question
Share on Google+
7 Replies


P: 36
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
Jan 8 '07 #2

P: 43
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?
Jan 8 '07 #3

P: 36
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
Jan 8 '07 #4

nico5038
Expert 2.5K+
P: 3,072
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)
Jan 9 '07 #5

pks00
Expert 100+
P: 280
You can easily read the inbox in outlook but then how do you know which email message 2 display?
Jan 9 '07 #6

P: 43
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??
Jan 10 '07 #7

P: 36
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??
Jan 10 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.