What folder to use?

[gujingc]

Hi,

Our team is building an application which would like to query and retrieve the newsletters published.

The published newsletter is listed now under an archive page.

One option is to create a crawler.

But a more elegant solution would be to grab the published newsletter in the folder they are stored. Can anyone enlighten us on what is the folder that all these archived newsletters are stored.

Thanks a lot.

[Stefano]

Hi, you can query the table “wp_newsletter_emails”, the email body is in the “message” fields. Filter the rows by “type=’message’ and status=’sent'”.
You can order by “send_on” or by id.

[Author]

Posts