MS Outlook inbox to MS Accsess Database


Joined
Jun 2, 2016
Messages
1
Reaction score
0
Alright a bit of background on what I'm using, and why I'm trying to accomplish this.
I have a personal financial database with access 2016 that I run on my home machine. The DB is for keeping track of my spent money, so it has the following areas which need to be filled in Entry number, transaction amount, category, date, title, and description. Normally when I get home I will input my transactions, but I want to just email my database with the info to add to it.

Some of the things you should know is, My entry number field is not autonumber. I hate autonumber and it is annoying to fix if you need to remove an entry for any reason. Entry date if possible could just be grabbed out of the email's received time if possible. The entry description is 255 characters max.

Now if possible I would love to have the email look something like this

____________________________________________________________________________________________________

111
-5.00
Online Services
Spotify
<insert
Multi
Line
Description
Here>

____________________________________________________________________________________________________

My hope is to just email my database, and have it automagicly add the entry to my database. This is so I don't have to remember to add it to the db later. Why not do it now?

If anymore info is needed to help me make this please let me know.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top