Receive email replies in Access

[KirstenD]

Help. I want to automatically send a rform or eport from Access via email (I
know how to do this). However, I want this email to be an "approve/reject"
email and I want the replies to go back to Access. Ultimately, I would like
the database to then proceed with another task after all persons have
approved. Is this even possible?

 

[Mark Andrews]

Everything is possible, however not always easy to do.

One approach might be something like:
- emails go out with a hyperlink in the body of the email
- when the user clicks the hyperlink it goes to a web page that lets them
approve/reject, the link is customized for each user so the web page already
knows who they are.
- the web site interacts with a table (probably in something like SQL
server) to store the approve/reject data
- the access database also has a link to this same table
- some kind of process to check if all people have approved/rejected for
access to continue it's tasks

Option2:
- Access uses outlook automation to read emails in a certain mailbox and
process them (I haven't done much of this, others might have more details on
this approach).

Hope that gave you some ideas.

My two cents,
Mark

 

[KirstenD]

Thanks Mark. It doesn't sound easy, but I'm always up for a challenge.

If anyone has more info regarding outlook automation to read emails in a
certain mailbox and process them, I sure would appreciate hearing from you.

Everything is possible, however not always easy to do.

One approach might be something like:
- emails go out with a hyperlink in the body of the email
- when the user clicks the hyperlink it goes to a web page that lets them
approve/reject, the link is customized for each user so the web page already
knows who they are.
- the web site interacts with a table (probably in something like SQL
server) to store the approve/reject data
- the access database also has a link to this same table
- some kind of process to check if all people have approved/rejected for
access to continue it's tasks

Option2:
- Access uses outlook automation to read emails in a certain mailbox and
process them (I haven't done much of this, others might have more details on
this approach).

Hope that gave you some ideas.

My two cents,
Mark

Help. I want to automatically send a rform or eport from Access via email
(I

[quoted text clipped - 4 lines]

the database to then proceed with another task after all persons have
approved. Is this even possible?

 

[Mark Andrews]

Try this link:
http://www.utteraccess.com/forums/showflat.php?Board=89&Number=1899163

or try searching on google "outlook automation" or reading email from
outlook etc...

HTH,
Mark
RPT Software
http://www.rptsoftware.com

Thanks Mark. It doesn't sound easy, but I'm always up for a challenge.

If anyone has more info regarding outlook automation to read emails in a
certain mailbox and process them, I sure would appreciate hearing from
you.

Everything is possible, however not always easy to do.

One approach might be something like:
- emails go out with a hyperlink in the body of the email
- when the user clicks the hyperlink it goes to a web page that lets them
approve/reject, the link is customized for each user so the web page
already
knows who they are.
- the web site interacts with a table (probably in something like SQL
server) to store the approve/reject data
- the access database also has a link to this same table
- some kind of process to check if all people have approved/rejected for
access to continue it's tasks

Option2:
- Access uses outlook automation to read emails in a certain mailbox and
process them (I haven't done much of this, others might have more details
on
this approach).

Hope that gave you some ideas.

My two cents,
Mark

Help. I want to automatically send a rform or eport from Access via
email
(I

[quoted text clipped - 4 lines]

the database to then proceed with another task after all persons have
approved. Is this even possible?

 

[KirstenD via AccessMonster.com]

Thanks Mark.

Try this link:
http://www.utteraccess.com/forums/showflat.php?Board=89&Number=1899163

or try searching on google "outlook automation" or reading email from
outlook etc...

HTH,
Mark
RPT Software
http://www.rptsoftware.com

Thanks Mark. It doesn't sound easy, but I'm always up for a challenge.

[quoted text clipped - 33 lines]

 

[Mike Painter]

Access 2007 has the ability to recieve and process email replies.
In previous versions you can connect to Outlook and parse the replies with a
bit of busy work.
I don't know what 2010 holds but it looks good so far.