Solved: Take info from Outlook and put it in Access

[rsilberfarb]

Hello All,

I have a process in place that Killian helped me out with a while back, but it is not as fail safe as I would like.

My goal is to take info from an e-mail and place certain elements into and access database.

Currently I have the e-mail save as a txt file, then paste it into Excel where I parse the data into the columns that I want, and then import that into Access.

All of this is done automatically with a combo of macros and VBA. The problem occurs if I get 2 e-mails at the same time, it all gets confused.

I was hoping some had an easier way to link the e-mail with access.

Thanks in advance,

Ross

[geekgirlau]

Can you post the code you're using currently?

[Killian]

Hi Ross,

It might be worth outlining the processes you're using currently. I seem to remember suspecting there was potential for this issue.

For reference and code, the relevant threads are here:
Original
and
Follow up

[rsilberfarb]

Basically, I have e-mails coming into outlook for service calls on one of our products. The could 20 or none in a given day. I want to be able to take the data from the e-mail and populte a table in an Access Database.

Currently I have oulook save the file as a txt, then open an Excell file with a shell command that runs a combination of VBa code and recorded marco to parse this data into columns. Part of the code opens Access and imports the info into the table.

Thanks for all your help

[rsilberfarb]

I think I have it figured out using much of what Killian help me out with before.

Thanks!

[Killian]

Cool... good job