Every now and then something goes wrong on one of my blogs, and I want to resend an existing post in my next MailPress newsletter. Perhaps I mess up something in the server configuration and mail starts getting lost, but I don’t notice for a few posts.
Creating a new post just so that it goes out in the next MailPress newsletter is a hassle. So here’s how to resend an existing post in your MailPress newsletter:
(Be warned, it involves hacking the WordPress database, which can destroy your site if you get it wrong…)
- On the dashboard, choose Posts → All Posts and Edit the post you want to (re)send
- Note the post id “post=n” in the URL
- In another browser window, go to your hosting provider’s control panel and open phpMyAdmin
- Select the WordPress database for your blog. If you don’t remember it’s name, open wp-config.php in your site’s root directory and look for the setting DB_NAME.
- Select the table wp_postmeta
- Select Sort By Key: post_id
- Find the entry with post_id “n” and meta_key “MailPress_published”
- Click Delete on that entry.
- Double-check that you’re only deleting that entry, not the whole table. (Doing that would destroy your blog).
- Back in the Edit Post window, click Update.
Your post will now go out in the next newsletter.
2 Comments
Aleksey · June 23, 2019 at 2:07 am
Also need to remove lines with _MailPress_prior_to_install if need to send letters before MailPress install.
vkool · November 8, 2013 at 11:42 pm
This writing is useful for me. I have been looking for ways to resend an existing post in my mailpress. I have learnt the way to do it from your post.