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?

Hi Stephen
Yes this is possible.
Firstly you need to write a Word Macro that opens an instance of Excel and the document that contains the data you want to read.
Once you have done that then to find the last row of data in an Excel sheet use this line of code:
LastRow = ActiveSheet.UsedRange.Rows.Count
You can then add the code to do your MailMerge.
Hope this helps.
Good luck.
Tony(OTPM)