Definitely not a question for this list, but perhaps I would be better doing the whole email to database in VBA?
On Thu, Mar 17, 2016 at 5:45 PM, Al Grant <bigal...@gmail.com> wrote: > Thanks Ken. > > Yes that's the only way I can see so far. > > There is a good outlook connector called moyosoft but it does cost about > $200 > > The field itself might be called CompanyXYZ Ave the data type longstring. > > I will also need record number in the email to update the correct record. > > Cheers > > Al > On 17/03/2016 5:28 pm, "Ken Bowen" <k...@form-runner.com> wrote: > >> What is the nature of the feedback into the database? >> >> If it amounts to more or less make entries in fields in the db, >> and you are stuck with email as a medium, you might hack up a >> convention like this: >> 1) Select a recognizable boundary line (begin & end), say a line of >> at least 10 + or *, or whatever. >> 2) Between the boundary lines, have your compatriots make entries like: >> [Field Name] = [Value to be input] >> with the restriction that no ‘=‘ sign occurs on either side (or replace >> the use of ‘=‘ by something else that would satisfy that restriction). >> >> You can knock out a script to process each email to a csv file, and >> then import that to your Access db. >> >> Regards, >> Ken Bowen >> >> On Mar 16, 2016, at 9:23 PM, Al Grant <bigal...@gmail.com> wrote: >> >> > Hi All >> > >> > This might be slightly OT - but the list was so helpful in the past... >> > >> > I have a database in MS Access and a standalone Java applet that imports >> > data from a PDF form and scrapes data from the PDF form into >> corresponding >> > fields in the Access Database. (Thanks to the list for help on this!) >> > >> > A report from this Access database then goes out via email to a handful >> of >> > people in other companies and they need a way to provide feedback into >> the >> > database. >> > >> > The question is how to achieve this feedback? >> > >> > It is difficult because the I am working within a number of constraints: >> > >> > 1. We are all working behind large corporate firewalls; >> > 2. I have Office 2007 installed; >> > 3. Our shared mailboxes are accessed only via a web interface (not OWA >> - I >> > think Lotus) >> > >> > Getting ports on firewall, vpns etc is not an option, nor are cloud >> > services like Dropbox or Amazon, so I think I am stuck with email as the >> > transport medium. >> > >> > Solutions? >> > >> > Cheers >> > >> > -AL >> > >> > -- >> > "Beat it punk!" >> > - Clint Eastwood >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@pdfbox.apache.org >> For additional commands, e-mail: users-h...@pdfbox.apache.org >> >> -- "Beat it punk!" - Clint Eastwood
