Letters with uniqe adress when printing

T

tzr

Joined
Jul 13, 2009
Messages
1
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing from ASP.NET1.1 2
Printing with OLE objects 2
Controlling Acrobat with VBA 1
Problem with format when printing to Word from Access 2
characters jump to left margin when printing 4
Calculating Days From Dates and printing letters. 3
Question with existing page numbering macro? 3
Need Help In Printing Current Record in Specific Report 1

Top