I am using Excel and Word 365 based on my laptop. Eventually my application will be ported to our company's 365 online account.

I have made several attempts to use a named, dynamic range for a mail merge but Word will not recognize the name. I have elected to use dynamic range because the number of data rows changes and I do not want to include any blank rows in the merge.

What are my options?

Steven