Email client within Access

[Daven Thrice]

I know how to send email out of Access, and that's no problem. What I need
to figure out is how to receive email into access.

Say that I give access an email address, such as ac****@daven.co m. I want
all email that comes to that address to be received directly by the database
so that I can parse out the files.

I'm thinking that, worst case, I can write my own email client using the
winsock control. But is that my only alternative?

Thanks!

dt

[Alan Webb]

Daven,
Tie MS Outlook and Access together. Outlook would deliver the mail to
Access and go from there.

"Daven Thrice" <da*********@NO yahooSPAM.com> wrote in message
news:xfSqd.1300 94$cJ3.21074@fe d1read06...

I know how to send email out of Access, and that's no problem. What I need
to figure out is how to receive email into access.

Say that I give access an email address, such as ac****@daven.co m. I want
all email that comes to that address to be received directly by the
database so that I can parse out the files.

I'm thinking that, worst case, I can write my own email client using the
winsock control. But is that my only alternative?

Thanks!

dt

[Daven Thrice]

"Alan Webb" <kn*****@hotmai l.com> wrote in message
news:-s************** ******@comcast. com...

Daven,
Tie MS Outlook and Access together. Outlook would deliver the mail to
Access and go from there.

I've been thinking about that. I've been wondering what all is involved in
doing something like that. I've written several routines in Access that do
things like schedule an appointment, create an email, or add a to-do item to
the task list. But that is all one-way communication.

In my mind, what I see would be simply attaching a table. In Outlook, I
would then setup a filter such that any email sent to the access@ account
would go into one particular folder, and I would then be able to view (and
work with) the email in Access, on a form and also within code (since there
is parsing involved).

The ability to add a few fields to the Outlook table would be nice, too. I
would assume there's some sort of unique primary key with each record, so I
should at least be able to create a relationship with another table.

Doing this without Outlook, though, would still be nice. I have the
Developers Toolkit (or whatever they call it now-days), so I can distribute
my application royalty free. Requiring an install of Outlook, which pretty
much requires (I think) an Office install, raises the stakes a little.

Too bad I can't just attach a table in Outlook Express.

Thanks for your input.

Daven

[David Schofield]

On Mon, 29 Nov 2004 23:59:41 -0800, "Daven Thrice"
<da*********@NO yahooSPAM.com> wrote:

Hi
See
http://support.microsoft.com/default...;en-us;Q290792
and refs there.
David

[David Schofield]

On Mon, 29 Nov 2004 23:59:41 -0800, "Daven Thrice"
<da*********@NO yahooSPAM.com> wrote:

Doing this without Outlook, though, would still be nice. I have the
Developers Toolkit (or whatever they call it now-days), so I can distribute
my application royalty free. Requiring an install of Outlook, which pretty
much requires (I think) an Office install, raises the stakes a little.

Too bad I can't just attach a table in Outlook Express.

Thanks for your input.

Daven

Hi
There are vb codes available for reading emails via POP3 for example,
but it is a hassle as you need to deal with the decoding as well.
One old example which I have used (this is actually in vb) can be
found at http://www.ericphelps.com/

David

[Tony Toews]

"Daven Thrice" <da*********@NO yahooSPAM.com> wrote:

I know how to send email out of Access, and that's no problem. What I need
to figure out is how to receive email into access.

See the Inserting data from incoming emails into tables tips page at
http://www.granite.ab.ca/access/emailincoming.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Steve]

Tony,

Your link, http://www.granite.ab.ca/access/emailincoming.htm , doesn't
work. I'm interested in reading your tip. How else can I get there?

Thanks!

Steve

"Tony Toews" <tt****@teluspl anet.net> wrote in message
news:13******** *************** *********@4ax.c om...

"Daven Thrice" <da*********@NO yahooSPAM.com> wrote:

I know how to send email out of Access, and that's no problem. What I needto figure out is how to receive email into access.

See the Inserting data from incoming emails into tables tips page at
http://www.granite.ab.ca/access/emailincoming.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Tony Toews]

"Steve" <no****@nospam. spam> wrote:

Your link, http://www.granite.ab.ca/access/emailincoming.htm , doesn't
work. I'm interested in reading your tip. How else can I get there?

My apologies. See http://www.granite.ab.ca/access/email/incoming.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm