MS Outlook inbox to MS Accsess Database

Discussion in 'Access' started by Mourt, Jun 2, 2016.

  1. Mourt

    Mourt

    Joined:
    Jun 2, 2016
    Messages:
    1
    Likes Received:
    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.
     
    Mourt, Jun 2, 2016
    #1
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.