A specific client sends out a newsletter every month. It contains a selection of articles from their website and a list of upcoming events.

Ideally, I would like to develop an extension that generates every month a draft Mosaico mailing with the content of the month.

Staff can then edit this newsletter using Mosaico (e.g. correct a title that's too long, remove/add an article manually...) and send out the mailing.

I see that the table civicrm_mailing contains a column template_options with JSON and that the property "mainBlocks" contains an array of blocks.

I could reverse engineer an existing template, but I was wondering if there is an API or a bunch of classes to create a Mosaico message?

1 Answer 1


A while ago SYSTOPIA and (mainly) Rich (artfulrobot) built two extensions that aimed at collecting external content and storing it in CiviCRM (newsstore) as well as one extension (NewsStore Mailer) which allows to create regular mailings with pre-defined templates that use those "content items".

The use case sounds very similar to what you have in mind. Unfortunately, the customer decided to not use the feature before we were able to fully test / finalize it. There may be incompatibilities with current CiviCRM versions, too.

However, they may be wort a look as a lot of work went into those and it looked very promising. Would love to see those used.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.