> > There is a good outlook connector called moyosoft but it does cost about > $200
I'm not sure why you'd use outlook at all. If the data is going to be available in email, use something that can fetch email silently and process the inbox as a batch process. To have a desktop application interact with Outlook is likely a bad design. Something like a silent IMAP processor would be much more scalable <https://pymotw.com/2/imaplib/>, in my opinion. :) - tres.finocchi...@gmail.com On Thu, Mar 17, 2016 at 12:45 AM, 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 > > > > >
