My first post! Any help is appreciated. I'm using Excel 2010.
I'm trying to mail merge just a portion of 1,890 addresses. In Excel, I successfully highlight and save the wanted addresses as a defined name. Then, in Word, after the Confirm Data Source dialog step and in the Microsoft Office Excel dialog box where you select "Named or cell range" my defined name does not appear. I can only get it to merge the entire 1,890-entries-long document.
I have been at this for hours reading help docs and watching tutorial videos on YouTube (which have been helpful) but I cannot figure out why my document is not doing what the Excel help doc says it should. I could cut and paste the wanted addresses into a new document but why do that if I don't have to and when there is already a function to avoid doing just that?
Any help is appreciated!
Bookmarks