A
Andy Levy
Hi
I have a customer database which stores the customers email address. I am
trying to create an access application that will work with MS Outlook to
track and store emails To and From people in the database.
The user writes the email in a form in Access and using the Outlook
library, the email is sent, and a copy is logged in the database. Thats the
easy part.
The hard part is receiving emails into the database, which i am trying to
figure out how to do.
So my first question is :-
1) in VBA - can i trigger Outlooks send/receive event for a specific
Account.
2) Is it possible to create an array, or in some way bring the content of
those emails into Access.
3) Is there any substantial online documentation for working with oulook
from inside access.
Thanks
AL
I have a customer database which stores the customers email address. I am
trying to create an access application that will work with MS Outlook to
track and store emails To and From people in the database.
The user writes the email in a form in Access and using the Outlook
library, the email is sent, and a copy is logged in the database. Thats the
easy part.
The hard part is receiving emails into the database, which i am trying to
figure out how to do.
So my first question is :-
1) in VBA - can i trigger Outlooks send/receive event for a specific
Account.
2) Is it possible to create an array, or in some way bring the content of
those emails into Access.
3) Is there any substantial online documentation for working with oulook
from inside access.
Thanks
AL