H
Hendy88
This is for the real heavy hitters out there. 
I have an idea but I'm not sure it's even possible or even where to
begin. First, I must say that I think it's great that people give
their opinions on here to help other people. I certainly learn by
doing/experimenting and hope one day I can return the favor when
someone else has a question. But anyway, enough mushy stuff.
My idea is this... would it be possible to start Access (or do this
every minute or so once Access is running), and have it check an
Outlook Inbox that has emails with spreadsheets attached... strip the
attachment... import those attachments into the database... then
delete the email (or at least show that it's been "READ"). The
spreadsheets coming in would be universal and would be the ONLY
messages coming in to that particular inbox.
Basically, what I see happening where I work is there's a designated
Outlook Inbox for people "in the field" to email their assessment.
Someone in the office then opens the email, saves the attachment, and
then runs an Access macro to grab information off the assessment and
append it into the database.
I was just wondering if you could automate the process and have Access
do all those steps on it's own. It would also be nice to have it
delete the email after it's appended it into the database, and leave
the emails with attachments that it couldn't append (for whatever
reason) so that someone could look at it manually and fix whatever the
problem is.
Any thoughts? Am I a crazy SOB? Thanks in advance.
I have an idea but I'm not sure it's even possible or even where to
begin. First, I must say that I think it's great that people give
their opinions on here to help other people. I certainly learn by
doing/experimenting and hope one day I can return the favor when
someone else has a question. But anyway, enough mushy stuff.
My idea is this... would it be possible to start Access (or do this
every minute or so once Access is running), and have it check an
Outlook Inbox that has emails with spreadsheets attached... strip the
attachment... import those attachments into the database... then
delete the email (or at least show that it's been "READ"). The
spreadsheets coming in would be universal and would be the ONLY
messages coming in to that particular inbox.
Basically, what I see happening where I work is there's a designated
Outlook Inbox for people "in the field" to email their assessment.
Someone in the office then opens the email, saves the attachment, and
then runs an Access macro to grab information off the assessment and
append it into the database.
I was just wondering if you could automate the process and have Access
do all those steps on it's own. It would also be nice to have it
delete the email after it's appended it into the database, and leave
the emails with attachments that it couldn't append (for whatever
reason) so that someone could look at it manually and fix whatever the
problem is.
Any thoughts? Am I a crazy SOB? Thanks in advance.