I am a beginner macro writer trying to write a macro that will automate printing labels from data in an Access 2000 database. I know the steps required in doing it within Access …. Tools –> Office Links —> Merge it with MS Word and when the Word window opens up, Tool –> Mail Merge … etc. I have so far written up to the point where I use the RunCommand and command: “WordMailMerge”, however, I am not able to bring the Word window into focus. It keeps the Access Database window in focus. Anyone with suggestions?
