how to read email content and save it in database using Access VBA

[sarathi57]

Hi,
I am new to Access VBA coding and i am finding difficulty in doing a functionality.

Requirement:

I need to open an Exchange email server like "

https://mail.aaaa@aaa.com".

it wil ask for Username and password. I will login into the exchange server and read the emails and copy the email content to the database. I need to read the content of the email and load it into the access database.

I need to do this automatically with access VBA.so that its
been scheduled to run daily.

Note: Outlook Exchange is not configured for this exchange server and hence we need to open the exchange server URL and need to do this.

It would be of great helpful if someone can help me
with the code.

 

[kjv1611]

Not sure if you've found any good help anywhere on this yet, but all in all, it may be a big daunting task. If you really want to do it, and/or need to, and have the time, then by all means go for it. You'll learn a lot from it, I'm sure.

Here's a Google search that seemed to give some possibly good sources of information.

Much of the results go to the same discussion in various forums, but regardless, I think you'll find out a lot of information from it.