Hey Otto,

On Sheet 1 is a list of all names of my contacts. On Sheet 2, there is over
300 page break sections with a address on each page, and its hyperlinked from
sheet1 to sheet 2.

Example:

Sheet 1: List of names
B
2 Brad Myatt <--Hyperlinked to Sheet2!d105
3 John Smith
4 Julie Roberts
-----------------------------------------------

Sheet 2:
D
105 Brad Myatt
14th Ave New York City
-----------------------------------------------

Then I have to press control print and print that specific page. I want it
so that when I click, it doesnt go to sheet 2 but just print that envelope
for me.

Hope this helps you so that you can help me.




"Otto Moehrbach" wrote:

Are you saying that you have 100 block ranges on another sheet with the name
and addresses of these 100 people, and when you want to print one envelope
for say, John Smith, you have to print that one range that contains his name
and address?
Certainly, that can be automated like you ask. But I don't think that what
you appear to have said you have is really what you have. Please post back
and clarify what you have in this "other" sheet. Provide some addresses for
a sample of a few addresses. HTH Otto
"Confused at Work" wrote in
message ...
I have a list on one sheet of 100 names. On a second sheet I have the
addresses of these people in a envelope sized space. Instead of going to
print and printing the specific pages can I not when I click on their name
get it to print that page automatically? Thanks, this would save me so
much
time.