I would like to adress a letter and and have a welcome frase to the receiver from a list in a separate sheet. Since i'm frequently sending about 300 letters the adress need to be automaticly uppdated att each print.
For example in sheet1 is the letter adressed to range A1:C100 in sheet2
I then whant to print 300 copies with the first letter adressed to cell A1 and so on.
Today i'm printing adress tickets but it would my nice to be able to make the letters more personal.
Sounds like a macro could solve my problem but it's not my speciality so some help would be appreciated!
For example in sheet1 is the letter adressed to range A1:C100 in sheet2
I then whant to print 300 copies with the first letter adressed to cell A1 and so on.
Today i'm printing adress tickets but it would my nice to be able to make the letters more personal.
Sounds like a macro could solve my problem but it's not my speciality so some help would be appreciated!