"Office's extensive functionality can't possibly cover all scenarios."
Not even something like pulling contact details from Outlook into a document without a VB macro, as per the OP?
Really? You did read the original poster, didn't you, or were you too busy looking for anything remotely critical of the one thing you know how to do?*
Office doesn't have to cover all scenarios, 99% of tasks which are currently attempted using VB Macros are just as basic as those listed by the OP. The rest should be left to those who know what they are doing, with the proper tools and not a language programmed through a WYSIWYG editor. (Yes, you can hand code VB, that's not the point).
* Yes, we've noticed how often you only reply to leap to the defence of VB, .Net and Microsoft in general. Your one man battle against the 'evil' conspiracy by those nasty open source types. Wait ... who first mentioned open source in this thread?