As membership director for a nonprofit organization, monthly I print and mail membership cards. To do so I use the same Excel spreadsheet for the recipient list for the cards themselves, a cover letter, an envelope, and often a donation thank-you letter.
For each document, I need to go through the entire process of specifying the recipient list:
- Click "Select Recipients"
- Click "Use an existing list"
- Choose a data file—I always have to click the folder drop-down because it defaults to "Documents", which I don't use.
- Navigate to the correct folder and select the spreadsheet
- Answer "Yes" to open the file if it is from a trusted source
- Select the appropriate sheet in the workbook
I must be missing something. Isn't there a simple option to select the last used database? I would think it would be the default.
Thanks for your help.
Jim
Word 16 for Mac