Gather record information from VBA in Word, incl XML

I use a lot of VBA in Word to automate referencing. Particularly, I need to implement my own automatic cross referencer because Endnote does not have this functionality.

It is relatively straightforward to access the field data within Endnote fields. It is XML from which I can pull out what I need, most of all record number.

E.g. { ADDIN EN.CITE <EndNote><Cite><Author>Someone</Author><Year>2025</Year><RecNum>123</RecNum> …

However, once the reference exceeds a certain size (i.e. once I’ve put sufficient research notes in it), this XML disappears. All you see is { ADDIN EN.CITE { ADDIN EN.CITE.DATA }}.

I’ve explored the field but simply cannot find any parseable data. At the moment I have to switch to text citations and then reformat them which is slow and cumbersome.

Is there a way to access this information from Word, please?

Thanks.