Sending and receiving emails with Ms Access

[Marek Bakalarczuk]

Hi.

I want to make A Document Management System.
Everything is fine and beautyfull but... how to hell I can receive
emails with attachements, and how to store it in Access database table.
I'm trying 3rd day and I can't find out enything clever.

If You can help me I'll be glad and very, very happy.

Maybe some useful links?

Thanks in advance,

Marek Bakalarczuk

[pietlinden]

Check this NG and the Outlook NG on how to detach the attachments and
save them to a specific folder. And why would you ever want to store
this stuff in your DB when you can read the Outlook inbox directly?
Well, unless you want to detach the attachments and save them
somewhere.

If you've been looking for 3 days and haven't found anything, you
haven't looked very hard. did you check the Outlook NG? Outlook MVP
sites? I mean, all you have to do is go to the Outlook NG or MS and
find the sites. They're freely posted there.

[pietlinden]

How about iterating through the (unread) messages collection, getting
each message's attachments collection and looping through it? then you
can process them one at a time... <scratching head>

[Emily Jones]

A bit harsh that. Why do you assume that the poster wants anything
whatsoever to do with Outlook? He talks about emails.

Some of us have done Outlook automation. It's frequently not that good.

Emily

<pi********@hotmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...

Check this NG and the Outlook NG on how to detach the attachments and
save them to a specific folder. And why would you ever want to store
this stuff in your DB when you can read the Outlook inbox directly?
Well, unless you want to detach the attachments and save them
somewhere.

If you've been looking for 3 days and haven't found anything, you
haven't looked very hard. did you check the Outlook NG? Outlook MVP
sites? I mean, all you have to do is go to the Outlook NG or MS and
find the sites. They're freely posted there.

[Marek Bakalarczuk]

pi********@hotmail.com napisal(a):

Check this NG and the Outlook NG on how to detach the attachments and
save them to a specific folder. And why would you ever want to store
this stuff in your DB when you can read the Outlook inbox directly?

Well, I need to make a DMS application in Access without or besides
Outlook.
It has to read messages from one folder and send it to receipient all
over the company.

Well, unless you want to detach the attachments and save them
somewhere.

Yes, I've found it. I need to save them somewhere on my HDD.

If you've been looking for 3 days and haven't found anything, you
haven't looked very hard. did you check the Outlook NG? Outlook MVP
sites? I mean, all you have to do is go to the Outlook NG or MS and
find the sites. They're freely posted there.

Yeah, it is true - I didn't look wery hard, because I've tried to make
it by myself :)

Thank for advice.

Marek

[pietlinden]

Marek,

found a link in here for ya... (watch the word wrap!!)

http://groups.google.com/group/comp....883cd1582f045b

If you look for Inbox+attachment you can find a bunch of them.
Like the poster says, move _backwards_ through the attachments
collection, because as you remove items, the count decreases. (makes
sense). If you try to go forwards, (using something like For
intCounter = 1 to Message.Attachments.Count (or whatever the real
syntax is), you'll end up pointing at attachments that no longer exist.

[pietlinden]

Marek,

found a link in here for ya... (watch the word wrap!!)

http://groups.google.com/group/comp....883cd1582f045b

If you look for "Inbox+attachment+MAPI" you can find a bunch of them.
Like the poster says, move _backwards_ through the attachments
collection, because as you remove items, the count decreases. (makes
sense). If you try to go forwards, (using something like For
intCounter = 1 to Message.Attachments.Count (or whatever the real
syntax is), you'll end up pointing at attachments that no longer exist.

[Marek Bakalarczuk]

pi********@hotmail.com napisal(a):

Marek,

found a link in here for ya... (watch the word wrap!!)

http://groups.google.com/group/comp....883cd1582f045b

If you look for "Inbox+attachment+MAPI" you can find a bunch of them.
Like the poster says, move _backwards_ through the attachments
collection, because as you remove items, the count decreases. (makes
sense). If you try to go forwards, (using something like For
intCounter = 1 to Message.Attachments.Count (or whatever the real
syntax is), you'll end up pointing at attachments that no longer exist.

Thanks a lot for this link.
I was googling since my last post and found very much useful things.