rsilberfarb
01-25-2006, 12:51 PM
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
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