I don’t have a simple solution to this problem.
On the other hand, I would prefer EndNote to continue behaving like it does now with double commas: Double commas are useful, I’ve found, for personal authors whose names end in a word element rather than initial. For example, “Ginneken, J. van”, which should not appear as “Ginneken, J. v.”, is output correctly if entered in EndNote as
Ginneken, J. van
That is, EndNote puts everything exactly as entered after double commas into the reference list, but omits it from the in-text citation.
As a workaround for corporate bodies with subordinate parts, I would
a) enter the author in the library reference as you have, i.e.
Society of College,bNational and University Libraries
b) edit the in-text citation in Word to exclude author, and enter the prefix as
Society of College,bNational and University Libraries,b
… where b is a blank space. If wanting to minimise typing and errors, the prefix can be copy-pasted from the preview window in EndNote, and thenthe “,b” typed after it.
If working with unformatted citations, this would be entered as
{Society of College, National and University Libraries, , 2008 #xx}
… where xx is the record number. This can be safely copy-pasted in Word for subsequent citations.
Cheers,
John