Ask Your Question

Connect of email application and read message body into Base with Basic

asked 2019-07-20 00:06:00 +0100

Steelman gravatar image

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.

edit retag flag offensive close merge delete


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?

Opaque gravatar imageOpaque ( 2019-07-20 01:21:40 +0100 )edit

See answer shown below Can it be done with base and thunderbird

Steelman gravatar imageSteelman ( 2019-07-21 04:06:33 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-07-21 03:52:48 +0100

Steelman gravatar image

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.

edit flag offensive delete link more


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 ...

Opaque gravatar imageOpaque ( 2019-07-21 12:43:25 +0100 )edit

answered 2019-07-20 05:15:48 +0100

lazarus477 gravatar image

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.

edit flag offensive delete link more


No money for online form and externa, darabase

Steelman gravatar imageSteelman ( 2019-07-21 04:04:05 +0100 )edit

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 ...(mehr)

lazarus477 gravatar imagelazarus477 ( 2019-07-22 01:02:53 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-20 00:06:00 +0100

Seen: 43 times

Last updated: Jul 21 '19