Okay that macro code worked and the template I've created opened up in Microsoft Word, but how do I then have the information in the "last row" from my excel table be populated into the word template when it opens up? Hope that makes sense.