I have never used the Shell function before, so I am not certain just how to get done what I need. I need to open Word from Access, then open a form letter template that gets its data from the Access database from which I am opening Word. Then merge the data and print the letters. I can open Word with the Shell function, but then when I attempt to open the form letter template, the SendKeys sends the information back to Access and not to Word. What do I need to do differently?
Thanks,
Bob
Thanks,
Bob