[SalesForce] A link to Content documents from a VF page

I've done similar things with a product called TRIM from HP rather than Sharepoint, but the basic principle is the same. In this case TRIM was accessible by users within the intranet and would hold the actual documents.

You create a custom object in Salesforce that can maintain the relationship between the Salesforce record and the unique identifier of the record stored in Sharepoint (probably a GUID).

You then create a formula field in Salesforce on the custom object that takes the GUID and creates a URL that the user within the intranet can access the sharepoint document with. For TRIM we were able to use a separate product called TRIM Easy Link.

The final part was to populate the relationship object in Salesforce when a document was uploaded to TRIM via the API.

There are a number of parts to such a solution, but it should work for Sharepoint as well.

I'm not aware of a native APEX and Visualforce option for completing this, but the paid Conga Composer and Conductor products can help you do what you're looking for.

Conga Composer

Conga Composer is an advanced Mail Merge engine for Salesforce and can merge multiple documents (up to 10) into one PDF for download. You're page would need to gather the IDs of the related documents and pass them to a conga composer point merge URL which would then merge the documents and initiate a download of the combined files. In the example below you're page would need to figure out the template ids and pass them into the TemplateId param.

Example Merge URL

https://www.appextremes.com/apps/Conga/PointMerge.aspx?sessionId=00DXXXXXXXXXXXXXXXXX&serverUrl=https%3A%2F%2Fcs13.salesforce.com%2Fservices%2FSoap%2Fu%2F8.0%2F00DW00000073T8i&id=a1NW000000162D2&TemplateId=06950000000Crmp

Conga Conductor

Conga Conductor allows you to do automate composer actions such as doing bulk merges. It would allow you to bulk download all the records and possibly merging them into one. The pricing on this can be prohibitive in some cases.