View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Megan Megan is offline
external usenet poster
 
Posts: 56
Default Data taken from a List

You could do a mail merge with a form document on Microsoft Word. This would
then print out each of the addresses on seperate pieces of paper and you only
hit print once. (you are able to review before you print).


--
If this has helped you, please click Yes

Thanks,
Megan


"James Dalton" wrote:

Hello all,
I have a little problem that I'm hoping someone with a bit more excel
knowledge than myself can sort out for me.
Basically I have a excel sheet which I am going to carry out surveys on
let's call this 'sheet 1' and on 'sheet 2' I have a whole list of addresses.
I need to print out a survey sheet for each address so I was wondering if
there is an easy way I can print these sheets out other than say physically
picking an address off the pull-down menu and hitting 'print' for each
address?
Any help you can give me would be greatly appreciated.
Many thanks,

JD.