Ok, so this is probably a bit messy but this my work around for the problem. Instead of auto posting, we really just need one post that is updated daily with information joined from another set of tables. 

I edited this script down a bit; the 'sampletable'  is a series of joins that was to wide and long for this post.

Update [Discussions].[dbo].[Posts]
Set [Discussions].[dbo].[Posts].[Body] = tblAgg.[AggData]
From
    (Select stuff((
     ( Select '  <p>' + col1 + ', ' + col2 + '</p>' 
       from sampletable
     ) as tblData
    for xml path(''),TYPE).value('.','varchar(max)')
    ), 1, 2, '' ) as AggData) as tblAGG
Where [Discussions].[dbo].[Posts].[Id] = IDnumberOfTargetedPost;