Bob <sm*******@hotmail.com> wrote:
A tough one!!!
Not really.
Is there any way that incoming eMails (MailItems) into Ms Outlook can be used to automatically
create records in a ms Access table or sub table.
Automatically? Depends on your definition of automatic. If you mean can Access
look every once in a while at the incoming emails in Outlook to see if there are new
emails then yes. But to have the record added to Access the moment the incoming
email is detected in Outlook then that would have to be done in Outlook.
Are you dealing with an Exchange Server? If so then Outlook is likely your best
answer. See the Outlook section at the below URL.
If it's a standard POP3 mailbox then there are other solutions available at the below
URL.
Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.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