Somehow many years ago a co-worker made a document with a formatting table (not an embedded excel table) that's used as a mail merge source for another document to make labels with. We've upgraded to 2010 and it's no longer working as it once did.



Is there a way to connect this table as a data source in 2010? I've been looking in to the XML schema, but I'm not sure that's the way to go. I've tried embedding an excel table into the document, but that's not as easy for them to edit and never looks quite right. I essentially need the ease of use of a formatting table with the functionality of an excel table. Is this possible? Am I totally missing something? I mostly work in Excel and with VBA, so this is a little out of my element.

Thanks!