Printing a word doc from an excel button
 

Hi,

I have an excel workbook with a linked word document. The workbook
contains lists of names and addresses and the word doc merely "pulls"
certain details from the worksheet as needed (ie company address).

How do I place a button on the worksheet so that when "pressed" it
automatically prints the word document with the details of the
currently displayed record in excel into the word document? Also, does
the user need to have opened the word document manually first?

Thanks,

Alec.


--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=511735