Re: How to check emails from Access

Hello,
Well I did a similar application but in Visual Basic. I raised a
reference to the Microsoft Outlook application . Then declared an object of
that type in my form like dim x as new object and set
X=createobject("Outlook.Application") then I could read all its methods and
properties of this object
Including I did create a part of my application that generated daily ,
monthly and personalized sales reports using CristalReports and sent this
report via email automatically to t he head office. I shall try to get
you a part of the code if you are still looking for it.
A part ,of it is

set y= x.createobject(OLMailitem)
y.recipients.add myEmail@server.dom
y.recipients.add myEmail@server.dom
y.body=text1.text
y.attachments.add filepath&name

y.send

But if its possible in Access will only be through VBA.
Thanks and best of luck.

Pradeep Kumar

"Dessie" <d_tzenova@hotmail.com> escribió en el mensaje
news:%23ZNWYnd2DHA.2680@TK2MSFTNGP11.phx.gbl...
> Hi!
> I have the following question - I want to check for new emails from my
> Access program from time to time. Every email will contain attachment
file,
> and I want every file to be saved in some directory for further processing
> from my Access program. Can I do all of this from Access?
> I try to add reference to Microsoft Outlook xx Object Library and then to
> use its methods but I didn't find any appropriate. I saw an "NewMail
Event"
> but coudn't managed to use it
> If anyone has an ideas to share with me, it will be great!
>
> Dessie.
>
> --
>
>
>
> .....................................
> ? ???? ????????? ???? ?? ?? ??????? ??????????? ?????????? (???. ? ?
> ??????????? ???????). ??? ?? ??? ????????? ????????, ???? ????????? ????
> ????????? (???. ? ? ??????????? ???????) ? ???? ????????? ???? ???????
> ?????????? ????
> ????????? ??????????????????? ???? (???).
>
> PRIVILEGED / CONFIDENTIAL INFORMATION MAY BE CONTAINED IN THIS MESSAGE
> (INCLUDING ANY ATTACHMENTS). IF YOU ARE NOT THE ADDRESSEE INDICATED IN
THIS
> MESSAGE PLEASE DESTROY THIS MESSAGE (INCLUDING ANY ATTACHMENTS) AND KINDLY
> NOTIFY THE SENDER BY REPLY E-MAIL.
> BULGARIAN HEALTH INSURANCE FUND (BZF)
> .....................................
>
>