# How do you do Newsletter? **URL:** \ **Category:** General Discussion\ **Created:** [October 22, 2016, 3:05pm UTC](https://forum.mautic.org/t/how-do-you-do-newsletter/6314 "2016-10-22T15:05:53Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![olafdammann](https://avatars.discourse-cdn.com/v4/letter/o/779978/32.png) [@olafdammann](https://forum.mautic.org/u/olafdammann)\ **Post date:** [October 22, 2016, 3:05pm UTC](https://forum.mautic.org/t/how-do-you-do-newsletter/6314/1 "2016-10-22T15:05:53Z")
All I have this general question. Talking about a regular Newsletter, send each week or so to all my subscribers. Not a welcome-campaign for new sumbscribers or so. I do it like this: 1. create the Mials 2. Create a Campain and add each Mail with its send-date to it 3. Add an “IF read THEN add a Point” to each mail-branch of the campaign. I find this extreeeeemly time consuming, as I need to create a freakin campaign every some weeks ![:(]( ":(") That lead me raising this question. Thanks for sharing your experiences OLAF ---
**Author:** ![olafdammann](https://avatars.discourse-cdn.com/v4/letter/o/779978/32.png) [@olafdammann](https://forum.mautic.org/u/olafdammann)\ **Post date:** [October 22, 2016, 3:05pm UTC](https://forum.mautic.org/t/how-do-you-do-newsletter/6314/2 "2016-10-22T15:05:53Z")
All I have this general question. Talking about a regular Newsletter, send each week or so to all my subscribers. Not a welcome-campaign for new sumbscribers or so. I do it like this: 1. create the Mials 2. Create a Campain and add each Mail with its send-date to it 3. Add an “IF read THEN add a Point” to each mail-branch of the campaign. I find this extreeeeemly time consuming, as I need to create a freakin campaign every some weeks ☹ That lead me raising this question. Thanks for sharing your experiences OLAF ---
**Author:** ![ninjoan](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ninjoan/32/1005_2.png) [@ninjoan](https://forum.mautic.org/u/ninjoan)\ **Post date:** [October 24, 2016, 1:51pm UTC](https://forum.mautic.org/t/how-do-you-do-newsletter/6314/3 "2016-10-24T13:51:34Z")
An excellent question right now I create the email each week since Mautic doesn’t have this feature already build. Before I have Mautic + Mailchimp combination but I change to create and send the email each time using Mautic with this I get some features that you can have using Mautic + Mailchimp. ---
**Author:** ![olafdammann](https://avatars.discourse-cdn.com/v4/letter/o/779978/32.png) [@olafdammann](https://forum.mautic.org/u/olafdammann)\ **Post date:** [October 27, 2016, 2:36am UTC](https://forum.mautic.org/t/how-do-you-do-newsletter/6314/4 "2016-10-27T02:36:36Z")
@ninjoan: Thanks for coming back on this 🙂 I think I would love to see it in such a way: 1. Open a new mail 2. write it 3. connect it to a Segment (and this setting should be storable as a template) 4. Give it a send-date 5. fire to me this permanent fiddling arround wirth new campaigns is useless effort ---
**Author:** ![MP2205](https://avatars.discourse-cdn.com/v4/letter/m/8c91f0/32.png) [@MP2205](https://forum.mautic.org/u/MP2205)\ **Post date:** [December 9, 2016, 12:32pm UTC](https://forum.mautic.org/t/how-do-you-do-newsletter/6314/5 "2016-12-09T12:32:31Z")
Very good question. We do too send once a week a newsletter to the same segement. So I would recommend not to create a campaign email but a segment email. You would then send the email manually to the segment on the send-date. Pro: no extra campaigns Con: every week a new segment email What do you do with “old” emails? When are you going to delete them or how do you archive them? ---
**Author:** ![ninjoan](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ninjoan/32/1005_2.png) [@ninjoan](https://forum.mautic.org/u/ninjoan)\ **Post date:** [December 9, 2016, 12:57pm UTC](https://forum.mautic.org/t/how-do-you-do-newsletter/6314/6 "2016-12-09T12:57:24Z")
The old email will be in Mautic. in my case, i create a Category called Newsletter so all my send newsletter email are there for any quick search ---
**Author:** ![amarinc89](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@amarinc89](https://forum.mautic.org/u/amarinc89)\ **Post date:** [November 23, 2017, 3:02am UTC](https://forum.mautic.org/t/how-do-you-do-newsletter/6314/7 "2017-11-23T03:02:40Z")
Since Mautic is integrated with Joomla and Wordpress, wouldn’t it make sense to be able to pull posts from these CMS to make regular scheduled newsletter as well? Creating new email every week is definitely a hassle. ---
**Author:** ![denispavliha](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@denispavliha](https://forum.mautic.org/u/denispavliha)\ **Post date:** [November 24, 2017, 2:05pm UTC](https://forum.mautic.org/t/how-do-you-do-newsletter/6314/8 "2017-11-24T14:05:13Z")
Well you should be able to pull posts and make newsletters out of them. 🙂 E.g., if you have self-hosted both Mautic and WP instances, I don’t see any limitations why you could not pull WordPress posts from its DB like this: [code]SELECT wp\_posts.id as post\_id, wp\_posts.post\_date, wp\_posts.post\_title, wp\_posts.post\_content, wp\_posts.post\_status, (SELECT name FROM wp\_terms WHERE term\_id = (SELECT term\_id FROM wp\_term\_taxonomy WHERE term\_taxonomy\_id=tti.term\_taxonomy\_id)) as post\_category, (SELECT slug FROM wp\_terms WHERE term\_id = (SELECT parent FROM wp\_term\_taxonomy WHERE term\_taxonomy\_id=tti.term\_taxonomy\_id)) as post\_parent, (SELECT display\_name FROM wp\_users WHERE ID=wp\_posts.post\_author) as post\_author FROM wp\_posts ``` INNER JOIN ( SELECT object_id, wp_term_relationships.term_taxonomy_id FROM wp_term_relationships INNER JOIN (SELECT wp_term_taxonomy.term_taxonomy_id FROM wp_term_taxonomy WHERE parent=INSERT_PARENT_ID_HERE OR parent=INSERT_ANOTHER_PARENT_ID_HERE) AS term_taxonomy ON wp_term_relationships.term_taxonomy_id = term_taxonomy.term_taxonomy_id ) AS news_posts ON wp_posts.id=news_posts.object_id LEFT OUTER JOIN ( SELECT term_taxonomy_id, object_id FROM wp_term_relationships ) AS tti ON tti.object_id = wp_posts.id WHERE wp_posts.post_status = 'publish' ORDER BY wp_posts.post_date DESC[/code] ``` and, then, process them and convert them into emails by pushing their HTML code into Mautic using [its REST API](https://developer.mautic.org/#create-email). So technically speaking, yes, you are able to do it. 🙂 Best, D.