Update field via email

[Homegrownandy]

I was wondering what the best method of data entry for emails recieved?



This is a general post, there are no restrictions or anything existing to worry about apart from the fact the information will be specific to a PK.

I was hoping to be able to make an input form but after a bit of looking i cant see anything like what i wanted.

So is the only way to manage updates about a specifit table/field to manually enter it?

[pbaldy]

I won't take a position on best, but there are any number of ways to get data from emails. I've created several automated imports from emails, either from attachments or in the body. Basically you need the email to be in some sort of predictable format. You can then parse the data out of it.

[Homegrownandy]

Seems like they removed this feature in 2013. thanks for the sugestion.

[pbaldy]

Oh, I'm not talking about the built-in functionality that existed for a version or two. I never tried that. I'm talking about using VBA code to examine the inbox, looking for a particular subject or something, then working with that email. Here's the link that got me started:

http://www.thatlldoit.com/Pages/howtosarticles.aspx

Specifically the "Saving an Email Attachment" section.

[Jen0dorf]

Hi

my proverbial 10 pennys worth.

I have used a webform in the past to into data into a database.

after many trials and tribulations I found this software

http://www.bebosoft.com/products/formstogo/overview/

I never used it for access ( thats my retirement learning curve) but it will do that and has built in captcha etc.

I still use it for my web forms when I design a web site

HTH

Ian

[Homegrownandy]

Thanks both, ill have to look into it more. I might end up making an excel form to email to them to fill in, then pulling the data from that. Just due to my skill level, i know i can achieve that. I'm disapointed they removed that feature though!