#1
|
|||
|
|||
use same recipient list for several documents
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:
Thanks for your help. Jim Word 16 for Mac |
#2
|
|||
|
|||
Hi!
There is a few things you can do to ease the process. Your card, cover letter, envelop, etc. aren't they template? If so, when you are in your template, do all the process to connect to the database then save your template. Next time you'll open your template, it will already be connected to the db. If you can't do that, you can put a shortcut of your Excel file into the default directory Word open to. Next time you'll have to connect to the database, you'll have less steps to do. Another option is to create an macro that automatically connect to the db. But you must know VBA. Good luck! Souriane |
#3
|
|||
|
|||
Quote:
Thank you very much for the suggestions. It occurred to me I might be able to solve my problem by using your first suggestion, but was reluctant to do so because every time I update the source data I revise the filename to include the current date, so I can keep track of the latest version. But I think I would be better served to keep the filename (and name of the relevant sheet) constant, and control my versions in some other way. Thanks again. Jim |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Choose recipient list | Arwydrunk | Mail Merge | 1 | 11-16-2020 12:38 PM |
mailmerge not using recipient list | jmcsa3 | Mail Merge | 5 | 11-07-2020 07:00 AM |
Sorting numerically in recipient list | greengauge | Mail Merge | 2 | 05-19-2013 09:58 AM |
How to edit recipient list | rsmedley | Mail Merge | 1 | 03-17-2012 01:35 AM |
Problem with Edit Recipient List | TanMan | Word | 0 | 10-05-2011 12:34 PM |