| Author |
 Topic  |
|
|
chinh10
Junior Member
125 Posts |
 Posted - 08 March 2002 : 12:04:21
|
Do you know any way or software: when some one email you (with an attachment). (I am using MS Outlook for receiving my email)
When I receive that email, also at a same time the contents of the email and the email address of the sender already insert to a database (any kind: SQL, Access, MySQL..)
Let say: my database names "MY_DB", table "FROM_OUTLOOK", columns:
"email", "Content", "attachment".
when someone email to me (with or w/o an attachment), when I receive it, my database already insert the new data:
email = customer@something.com
content = something in your email
attach = filename (or not)
Please let me know if you know any software do this kind of thing?
Thanks in advance!
P/S I already setup a SQL Mail from MS SQL, but do'nt know how to implement it to the Database:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556
The reason I need your help b/c I want to collect all of the email send to me into a Database then I can tracking all of my email from that database (including the attachment files)
Edited by - chinh10 on 08 March 2002 12:04:49 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 08 March 2002 : 12:51:43
|
You would need to write your own application to do this.
You can email queries to the SQL Mail account, but they must be propper queries with no other data in the emails (and you can only do this with SQL server).
Would you are asking has been discussed before, and is simply not possible unless you write a mail processing application.
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 March 2002 : 13:08:17
|
It is possible to open an Outlook Application from within Access and get all the info available in Outlook and write to a DB.
Likewise it is possible to write info to any database accessible through ADO from VBA code written in Outlook. I've done both things before.
So it is doable. It need some info on this, but it is not too hard. I got my info from Access Developer's Handbook, Vol1.,Sybex. They have one or two chapters on Office Automation using VBA. That info, coupled with MSDN, will be all you need.
Unfortunately it is simply too much to explain in a forum like this. I suggest you find this book, or another good book on Office Automation.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 08 March 2002 : 13:58:53
|
It seems a bit pointless doing this, outlook is in effect it's own database, so why would you want to track everything twice.
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 08 March 2002 : 14:00:39
|
If you have Outlook and not Outlook Express, it's actually easy to capture email info and insert in a database.
In general open Tools - Macro - VBA Editor and use VBA to open a database connection and copy email information to the database.
You will have access to all the email elements and whatever recordset you've defined.
There may even be an easier way, but if you know VBA at all it's pretty easy to program in Outlook. Much easier than trying to get Outlook data from outside Outlook, although as ruirib said it can be done that way too.
Outlook Help and MSDN are your friends to find out how to do this.
If you want to start wading in this pond, look up MS KB article Q146636
======
Doug G
====== |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 08 March 2002 : 14:03:47
|
quote:
It seems a bit pointless doing this, outlook is in effect it's own database, so why would you want to track everything twice.
only thing i can guess is so they can have the emails where he can view them on the internet, this way he can check his email from anywhere.
Brad
Web Hosting with SQL Server @ $24.95 per month
Snitz Mod Archive
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 March 2002 : 15:16:29
|
quote:
It seems a bit pointless doing this, outlook is in effect it's own database, so why would you want to track everything twice.
Well I have a members database for an organization of which I am also a member, which has members various details, and a lot more. These guys are not in my contact list, as they are not my personal contacts. So, whenever I want to email them it is easier to do it directly from my database app, using Outlook to compose and send the mail, and using emails registered on the Access DB.
Initially I did it from Outlook so there is no difficulties doing it either way.
I don't know about Outlook enough, but I don't think it is just an ordinary database. If you need additional info besides the email contents, probably using Access to complement that info can make sense.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 08 March 2002 16:01:04 |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 08 March 2002 : 19:56:23
|
There are a few very good reasons to want to extract something from Outlook and put it in a db. I'm currently working on a project that is similar.
======
Doug G
====== |
|
|
|
Ronald
Starting Member
United Kingdom
29 Posts |
Posted - 09 March 2002 : 12:28:10
|
Has any one done a mod for a bidirectional mailing list to forum gateway?
Regards -- Ronald
No Limits
http://www.skiing.plc.uk |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 09 March 2002 : 13:37:27
|
quote:
Has any one done a mod for a bidirectional mailing list to forum gateway?
Regards -- Ronald
No Limits
http://www.skiing.plc.uk
No not that has been released generally. I did write an application for a client when I first got involved with Snitz, because they were moving from a newgroup to a forum, and thought that his functionality would ease the transition. It didn't, and so few people used the option that it was removed after just over a month.
A few people have asked about this, but the amount o interest does not justify doing it. It only has limited apeal, since really you would need your own server to run it on, unless you were using SQL as your DB, then you could run the mail server locally.
|
|
|
| |
Topic |
|
Topic Locked
