Total Length of Members in Assembly?

I was wonding if there was a way (probably a macro) that could extract the total length required for each member used in weldments that make up a top-level assembly?

For example:

Weldment A:

W8x31 - 2' long

W8x31 - 4' long, etc

Weldment B:

W8x31 - 10' long

W8x31 - 5' Long

Assembly of Weldments A and B

W8x31 - 21' Total Length

This would be done for every type of member - W Flanges, C-Channels, etc.

Basically I would like a list of what member are required for the entire project - including total length.

Thank you so much!

Regards,

John Lega

SolidworksWeldments