How do I create an excel document that auto populates to a microsoft word document? I recieved an excel document that allows me to input information such as names and birthdates and then i click a tab and it auto populates to a given sentence on a microsoft word document. For example, on Excel spread sheet, I input John 03/03/2003 and Jill 04/04/2004 and it auto populates to a micrsoft word document narrative, ” On 04/01/2019 while walking the streets in Illinois, John 03/03/2003 was hit by a vehicle driven by Jill 04/04/2004. However, I need to creat one from scratch. I am using Excel 365.