Create a macro to export data from body of email to access database

[GetToTheGate]

So I am a complete newbie. I know vaguely from google searches that this type of thing is possible but I have no idea how to go about it.

I get a specific email multiple times a day, I have a rule sending them to a specific folder. Those emails are a form people fill out and I need that data in my access database. At this time I enter in everything manually and I would really like to streamline the process and stop wasting time.

So the data is this:

Date Pet was Lost
Pet's Name
Type of Pet
Sex
Location Lost
Color
Ears
Coat
Coat Texture
Tail
Recently groomed?
Declawed?
Describe Your Pet
Was your pet wearing a collar?
File
	Photo
Your Name
Phone
Email
	I think what I need is a macro. I don't necessarily want it running in the background or anything. I don't mind opening outlook and my database and running whatever it is I need to do. Does this make sense? Am I posting in the right place?

[orange]

Please tell us more about your Access database.

There is a free data model for lost and found Pets here.

Welcome and good luck with your project.

[GetToTheGate]

My fiancé made the database, he's in IT but doesn't really know how to do a lot with databases. I have a form where I enter in the data:




I have a pet info table and an owner info table. Am I answering your question right?

[aytee111]

Start by linking to the Inbox
- External Data
- more
- Outlook

Then follow the wizard. Now you have all your emails available to you in Access. Look at the data and decide what you want to extract, then create a query for it.

[GetToTheGate]

I have tried that before. All that way does is extract the emails and subject of those emails. It creates a new table. I want the data from the body of the email. If I can't do it straight to access because the database is set up different then the report I understand that. I could export the data from outlook into excel and then put the columns in the right order to import into the database.

[aytee111]

Linking does not create a new table, it creates a pointer to the existing "table" in Outlook. It does not extract either, so not sure what you have tried before. What Outlook are you using?

[GetToTheGate]

2010.
So choose the third option? I was choosing the first option.

[aytee111]

Yup! That will give you access to the body of the emails.

[GetToTheGate]

All it did was grab the inbox data.

[aytee111]

I thought that was what you wanted?

[GetToTheGate]

No, that is just the subject of the email, the email address. I am wanting the data from the body of the email. The stuff from the very first post, the list (the answers to those questions).

[aytee111]

It is in the column "Contents". You can use the InStr function to parse out what you want.

[GetToTheGate]

It is in the column "Contents". You can use the InStr function to parse out what you want.

The contents it brought over is only the first sentence of the email body unfortunately.

[aytee111]

Not sure why that is, for me it is the entire email body. Did you copy and paste it into something like Notepad or did you just visually look at it?

[GetToTheGate]

I just visually looked at it. When I select the contents of that cell it shows me everything.