How do I create a connection to the email application, read the message into a variable and then write the contents of the variable into a field. I have a web based form that is filled in and sent to my email. I want to transfer the body of the message into a Base table. Once the message is in the table, I will look for the titles (First name, Last Name, Email Address, etc.) within the email and read the data in these lines into variables then transfer this data into a table that his fields like FirstName, LastName, EmailAddress, HomePhone, MobilePhone etc.
What do you mean by “…the email application”? Is it a local email client lile outlook, thunderbird, KMail, Opera Mail, Pegasus, plain mbox, to name a few, or are you talking about an web-based email application, which would require to establish a http(s) connection?
See answer shown below Can it be done with base and thunderbird
Rather than do all that why don’t you instead put up an online form which stores the user entered data in an external database. Then connect to the external database from Base? Saves you all the fuss of reading in data submitted via emails.
No money for online form and externa, darabase
Online hosting is not expensive, just find the right low cost service. All you need is the most basic setup, a web server with PHP and a database. Look into it.
My suggestions are based on reality and how I personally think you should solve your problem. You are asking for a screwdriver but what you need is a hammer…
Even a non-profit organisation has some form of funding, be it from a council, member fees or donations. They might even sell something such as goods or lottery tickets.
they need to factor into their budget the expense of online hosting. I am sure they already pay for electricity, phone usage, coffee and snacks and so on.
I understand the wish to keep things low cost but solving the problem your way is going to become a headache, sooner or later and then you will all wish you had chosen a more dependable solution which is online hosting.
I do this now with ms office (access & outlook). I am trying to move away from ms and use libreoffice and thunderbird
It’s done for a nonprofit organization and I’m trying to prepare the application with free software.
Please do not user “Answer” function, if actually not answering a question but responding to a request for information. Edit your original question or use add a comment function. Answer is supposed to be reserved for real solutions to a question on this site. Thanks in advance …