scottylad2
Well-known Member
- Joined
- Feb 2, 2009
- Messages
- 1,922
Hi everyone. I have a membership data base in Excel, and I've worked out how to do a mail merge using Word and the Names and addresses contained in my Excel file. As per the help file instructions, i've named the range where my names and addresses are contained, but next year my list could be bigger or smaller than this year, is there a way to have the named range dynamic to include only rows that contain data? Needs to be a formula, and has to be in Excel
my Column headers starting in A1:D1 are First name Last name Address Postcode and this year go to Row 1005, and i've named the range MyNa
es for the purposes of doing the renewal mailing
thanks
my Column headers starting in A1:D1 are First name Last name Address Postcode and this year go to Row 1005, and i've named the range MyNa
es for the purposes of doing the renewal mailing
thanks