Solved Is this possible - checking a checkbox from an email?

[Sam Summers]

I am currently trying to find something in order to achieve this but just wondered if a member knows if this is even possible?

I basically want to enable a person to approve something in a record by setting a checkbox in the same record to true via email

 

[conception_native_0123]

you can include information in an email that is from the access database, but if you want to interact with access through outlook or any other email client and have information be manipulated inside access from the email client, you'll have to put something interactive in the email like a button so that access can be initiated and instantiated.

 

[arnelgp]

just some thought.

the approving party must have a db with authorization code table.
this table holds random characters.

same table is in the user db (but hidden).
you add a code to a form that ask authorization code, so he may be
allowed to enter his record.

the approving party/manager send this code from email.
once the code is used, it is Ticked (as used) in his table.

at the same time the user will received this code through
email. once correctly entered, he may be allowed to continue
his data entry (po in your case). and also this code is Ticked (as used)
in the table, so entering same will trigger a msg that the code has
already been used.

ofcourse the implemtation is up to you.

 

[Sam Summers]

Many thanks to both of you.

I will try and figure something out.......

 

[bastanu]

Please have a look at my free Outlook importer:http://forestbyte.com/ms-access-utilities/fba-outlook-email-parser-importer/

You can set up a folder in a shared mailbox and have Access loop through all the messages in there and process them individually. So the approver should just send a message with a predictable subject such as Order ID: 12345 Status: APPROVED or Order ID: 99999 Status: NOT APPROVED. In the looping code you then just have to add an update statement to update the status for each of the orders.

Cheers,

 

[Sam Summers]

just some thought.

the approving party must have a db with authorization code table.
this table holds random characters.

same table is in the user db (but hidden).
you add a code to a form that ask authorization code, so he may be
allowed to enter his record.

the approving party/manager send this code from email.
once the code is used, it is Ticked (as used) in his table.

at the same time the user will received this code through
email. once correctly entered, he may be allowed to continue
his data entry (po in your case). and also this code is Ticked (as used)
in the table, so entering same will trigger a msg that the code has
already been used.

ofcourse the implemtation is up to you.

So far Arnel i am going with your method which i think will work fine. I will post on here when i have it completed.

 

[Sam Summers]

Hi guys, I looked at yours Vlad but decided to go with Arnels method as it suited our simpler system better but thank you everyone.

I created a randomised string and inserted it into the record and then incorporated it into the approval email header. Once the approver replied, the user copies the string into the relevant records approval textbox which then checks that the strings match and the order is approved automatically.
It works a treat and for us is a very effective way to approve items even from the approvers phone!