Thread: Printing using macros

Hi. I need some help regarding printing letters/correspondence using macros. I have a workbook with two sheets in it. Sheet1 contains a table of names, home addresses, and cities. It also has a corresponding number for each range/row. Sheet2 contains the format of my letter, which i made a link to sheet1. On cell A1 of sheet2 i encode or type the number that corresponds to the each range/row that has a name, address, city to be print. Can anybody please help me print them all without encoding the corresponding number one at a time? I tried recording a macro by a batch of 10. But if i have more than 10 letters to be sent, i have to encode "11" and "12" and so forth... hope someone can help me thanks.