Need advice on best way to add an article to the blogs of multiple users

I have over a hundred separate users who have blog articles.

We need to add articles in mass to all of their blogs rather than having them individually add the blog article.

What strategy or process would you recommend we use so an admin can do this process. We know it's unlikely that such a feature is built in but you guys are really good... and often have this sort of thing already done.

But, assuming such a feature is not currently available, we could create the feature ourselves but would need help to identify what tables, etc to use.

Any insight, ideas or suggestions would be much appreciated.

Thanks!

Depending on how often you need to do this (once or every day changes this):

If it's once, just write one blog entry, check in SQL its storage (depending on your blog storage choosen, if it's Joomla articles, it's in #__content SQL table. Then design a SQL query to insert the entries.

Then either execute manually in phpmyadmin if it's once, or if you want to automate the process, you can probably use CB Auto-Actions to trigger that SQL action.

Thanks Beat, appreciate the fast response!