by David Hakala
Suppose you have a database of company information and contacts. You want to use an Excel macro to copy addresses and such into different Word documents. How can you make Excel open a specific Word document into which information will be pasted?
Word’s mail merge feature is one solution. But if you are working with multiple Word documents, the mail merge trick won’t work. You will need something more complicated called Office Automation, which allows creation of macros that work with multiple Office applications and not just one, such as Word.
(more…)