Quote:
Originally Posted by Souriane
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
|
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
02-22-2022, 08:22 PM
Similar Threads
Choose recipient list
Mac OS X 
Office for Mac 2011
Threaded Mode