We recently upgraded from BV2004 to BV5.6. We want to generate mailing labels for all unshipped, paid orders.

The "ShippingAddress" field in bvc_Order contains a bunch of tags for the entire address: firstname, lastname, city, etc.

Wondering if there's a stored procedure that pulls each item out of that field so I can insert the items into a spreadsheet for a mail merge?

Thanks.

I spoke too soon, I followed the directions, even fixed the names of the fields. I receive this error:

The XML parse error 0xc00ce556 occurred on line number 1, near the XML text "f3af14e36845</Bvin><NickName /><FirstName>t</FirstName><MiddleInitial /><LastName>t</LastName><Company>test</Company><Line1>t</Line1><Line2 /><Line3 /><City>t</City><RegionName>DC</RegionName><RegionBvin>16f5837c-7516-4c91-b592-09518f75f843</RegionBvin><PostalCode>t</PostalCode><CountryName>United States</CountryName><CountryBvin>bf7389a2-9b21-4d33-b276-23c9c18ea0c0</CountryBvin><Phone>222-222-2222</Phone><Fax /><WebSiteUrl /><CountyName /><CountyBvin /><UserBvin /><Residential>false</Residential><LastUpdated>0001-01-01T00:00:00</LastUpdated></Address>".
Msg 6602, Level 16, State 2, Procedure sp_xml_preparedocument, Line 1
The error description is 'Invalid at the top level of the document.'.
Msg 8179, Level 16, State 5, Procedure bvc_AddressXml_s, Line 17
Could not find prepared statement with handle 0.