Hi,

Your request is not particularly clear -- telling us what the end goal is would help -- but I think the answer is neither the mailman menu nor the phpmyadmin can do what you want.

That is assuming that you want to send some tabular information to people via email, where the recipients are managed via mailman.

Consider the parts of your process:

 1) some data source, which you have not mentioned.

 2) something that stores data from the source into MySQL tables.

 3) something that creates html page text from the MySQL tables, that can be delivered by an http server.

 4) something that creates an email message from the data in the MySQL tables.

 5) something that sends the email message to an MTA (such as exim, postfix, etc).

 6) something that stores and manages the email recipients to whom the data is sent (= Mailman + postorius etc).

I think you must have something that manages (1), (2), and (3), as you mention that you have a web page that works. This solution likely uses php and nginx.

[ Note that a web page never sends an email. It is possible for (eg) PHP programs to send an email, and it can be the case that a php program that is generating html for a web page can also generate an email message and send it, but that is to conflate two quite different processes unnecessarily. ]

You still need (4) and (5), which mailman cannot help with but for which libraries like PHPMailer, and programs like exim, can help.

The message to your recipients will be sent in (5) to mailman using an email address to mailman core which is set up as a posting non-member of the list, so it doesn't also get copies of mails sent.

Hope this helps,

Ruth

On 01/06/2021 21:46, Zden Pos via Mailman-users wrote:

I'm trying to connect existing MySQL data to the Mailman distribution list. Actually, a message is sent from the web page. It remains on this page and is also stored in the MySQL table on the provider server. This is working fine. I have also existing Mailman distribution list generated from the cPanel on the provider server as well. This list is working fine when used for a direct mailing.

I need to link the MySQL table to the Mailman distribution list. When the message is posted on the web page and stored in the MySQL table, it is also to be sent to members as per the Mailman distribution list. I don't know where to configure it. In the phpMyAdmn page of the MySQL or in the Malman menu ?

Thank you for your help

---

Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/

-- Software Manager & Engineer Tel: 01223 414180 Blog: http://www.ivimey.org/blog LinkedIn: http://uk.linkedin.com/in/ruthivimeycook/