Integration of Word and Excel

[stephen_pen]

Hello, everyone,
I have a new job and will be responsible for the company's weekly Newsletter. I plan to create and Excel table with each row holding the complete text for the Newsletter by topics (in columns). Each week is a new row.

When I open the Newsletter template in Word 2010, it should open this Excel table, use the last row only and fill in the provided fields with text from Excel.

Then Mail Merge will open the address table and email the newsletter to each customer.

Question: How can I make Word 2010 to read the text from the last row of Excel table? And will this action take place BEFORE Mail Merge?