Automation in the context of programming is the ability to control one program with another. In this case, it is using Python to control other applications.
MicrosoftOffice - Controlling/scripting the Office applications
pyWinAuto
SendKeys
watsup