is there a way to add a prefix to the automatically generated revision number or letter. We have been acquired by a company that uses X01, X02, .etc for development revisions before release.
There is no auto way as by default it will come as numeric or alphabet (as per setting in Document options).
Setup a property (under File > Properties) named Revision and set the table to read this property.
If the change is the same, you may be able to use a macro for batch operations. Places to look are http://lennyworks.com, http://sw.fcsuper.com and the SolidWorks API page (I don't have the current link). There also may be something in the 3DCC under macros.
If a macro isn't your solution, you can look at BatchProcess at http://angelsix.com.
Retrieving data ...