944,051 Members | Top Members by Rank

Web Development > Databases > Database Design > web based datbase question about email
Ad:
Permalink
Aug 30th, 2007
0

web based datbase question about email

Expand Post »
Hi,

I am a student on my year work placement and I have been asked to develop a web based database for a company. I think my design is ok but I am a bit confused in a part...

The company wish to save emails in the database to and from customers, is this possible or how would i go about doing this? I have read quite a lot but i can't find anything that is what i need. It is not that the emails will hold information for an order specifically, there will not ba a email form or template, just generally saving the messages and dates etc. so other members of staff know what has been said to the customer etc.

Any ideas would be greatly appreciated!

Thanks
Similar Threads
GLT
Reputation Points: 18
Solved Threads: 0
Junior Poster in Training
GLT is offline Offline
98 posts
since Aug 2007
Permalink
Aug 31st, 2007
0

Re: web based datbase question about email

i realise i didnt word that question very well...

basically all im asking is, is there a way of saving emails to a database table? and how would i do it?

Thanks!
GLT
Reputation Points: 18
Solved Threads: 0
Junior Poster in Training
GLT is offline Offline
98 posts
since Aug 2007
Permalink
Sep 1st, 2007
0

Re: web based datbase question about email

You can store the details of the mails in a separate table with fileds like date,from,subject, contents ect.
Featured Poster
Reputation Points: 665
Solved Threads: 427
Posting Genius
debasisdas is offline Offline
6,406 posts
since Feb 2007
Permalink
Sep 3rd, 2007
0

Re: web based datbase question about email

Click to Expand / Collapse  Quote originally posted by debasisdas ...
You can store the details of the mails in a separate table with fileds like date,from,subject, contents ect.
Thanks but, how would I make the connection between the database and Outlook?

I'm beginning to think, I'm thinking about this problem is more complicated than it is.
GLT
Reputation Points: 18
Solved Threads: 0
Junior Poster in Training
GLT is offline Offline
98 posts
since Aug 2007
Permalink
Sep 5th, 2007
0

Re: web based datbase question about email

Click to Expand / Collapse  Quote originally posted by GLT ...
Thanks but, how would I make the connection between the database and Outlook?

I'm beginning to think, I'm thinking about this problem is more complicated than it is.
The best thing to do is to ask for clarification, if they want you to integrate it into Outlook or their e-mail server I think thats a bit beyond just Database design.
Reputation Points: 22
Solved Threads: 1
Light Poster
matale is offline Offline
38 posts
since May 2007
Permalink
Sep 10th, 2007
0

Re: web based datbase question about email

would using SQL Mail work?
would this need a whole database dedicated to it or would I be able to use a table within my databasefor this?

any ideas greatly appreciated!!!!

Thanks!
GLT
Reputation Points: 18
Solved Threads: 0
Junior Poster in Training
GLT is offline Offline
98 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: Design help plz
Next Thread in Database Design Forum Timeline: On Delete Cascade





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC