Is there a way I can send details of emails in Outlook to my Access Database?

[alexandervj]

I have a contact form on our website which sends an email to the business dev team saying that the user has requested to be sent product sheets. The email contains the users name, email, phone number, and a few other fields. Is there a way I can send the details of these emails to my access database automatically?

[ItsMe]

You will have to have access to the website DB. Are you hosting the website? Are you using SharePoint? Another approach would be to Cc another email address and import the data to our DB somehow.

[alexandervj]

Thanks for the reply,
I do have access to the website database and I am using SharePoint, although I might take it off sharepoint. I want to have it email certain people if certain actions aren't taken in certain amounts of time along the process of responding to each request. I'm not sure if a SharePoint web database has that capability

[ItsMe]

I am not hip to the whole SharePoint thing either. My line of thinking is that the form the user completes stores data in tables. You could link to these tables and get the information this way. You can use Booleans to determine status of email sent, action taken, remote DB updated, etc.

[alexandervj]

Yeah SharePoint is a pain, not to mention you lose a lot of functionality with the web database than desktop database.
I found this ...
http://office.microsoft.com/en-us/ac...010015427.aspx
it looks like there might be a way to do it through that but not sure of the specifics. It would be nice if I could just take the email that the contact form sends and send/move it to the database if the request in the form is approved somehow

[ItsMe]

That link seems to attach an email to an attachment field in a table. Seems counterproductive.

If you have access to the webserver then have the webserver send an additional email. It could be Bcc or Cc with the original or it could be a separate one that attaches a file that has the data you need. Then a user could monitor the email and upload the attached file or email message to the DB, populating the respective fields in the local DB's tables.

I do not see why you would not be able to have a local DB connect to the SharePoint server directly. This seems to be the most logical approach. You just need a connection to the tables. Then, a user could monitor real-time data regarding email activity/requests.

[alexandervj]

woops sent you the wrong link. Check this out. This is what I want to do
http://www.youtube.com/watch?v=3uhYu-2J7k8
I did it and it seems to work, however wont work with a web database, which isnt a huge deal, I'll just make a split database and put it on the network. But that seems to work, now all I have to figure out is how to craft the emails that go into the linked outlook folder so that the right data shows up in the right fields

[ItsMe]

..... now all I have to figure out is how to craft the emails that go into the linked outlook folder so that the right data shows up in the right fields

I have played around with some of the Access wizards that link to Outlook. There seems to be many constraints regarding the actual functionality linking provides. In the long run, this approach may be more work. Is there a reason you are not interested in pursuing the idea of linking to the database that has the user request form?

[alexandervj]

I guess I could do that as well. Its a WordPress site so I'm not sure of the specific tables, etc that capture the data from the web forms. I was hoping this would be a more straightforward solution but you might be right, I may just have to end up going about it that way

[ItsMe]

I was under the impression you are using your own DB on a SharePoint Server. You may want to ask WorPress if they offer an API option. Anyway, you will have to inquire with them and see what options they may offer.

Maybe you can navigate in your web directory and see if there is a DB in there. Alternatively, there may be a text file or XML file that keeps data on all of the requests from users. If you have access, you could just copy that file and import that to your DB.