I have a fairly basic DNN site for a niche B2B magazine. At the moment I have a page for each article that appears in the monthly editions. These appear as /PublishedArticles/MonthYYYY/ArticleName.aspx
Each page has a HTML Module containing the text and images for that article.
I can enable the "Allow Syndication" option and can see that this gives me an RSS feed for that module. That however gives me an RSS feed per page and that only contains 1 article per feed.
So, the question. Is it possible to combine the content of the multiple HTML Modules over the multiple pages and generate one RSS Feed for the Published Articles?
If I have to go down the route of a different module, that may be possible, there around 300 articles already in the site from the past year so I'd rather preserve them than destroy as most have a number of inbound links to them too.
Perhaps there is some SQL I can run to generate the source data for the RSS feed?
All ideas gratefully received.