We are trying to leverage Sharepoint 2010 as an internal newsletter mailer within our company. So far we have a document library set up where HTML files are uploaded and then a site page where the files can be browsed at the user's leisure.
There is a workflow in place so that everytime a new HTML file is uploaded to the library, Sharepoint will send out an email to all users in our company with a link to the new news item for viewing.
We would like to use the HTML content as the actual body of the email. So far I have done some digging and haven't found any examples of how to do this. SPD 2010 doesn't seem to have a "document body" or "document content" lookup field in its workflow designer.
Does anyone have an idea of how to accomplish this?