Writing Letters from Excel

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

Does anyone know if/how XL can be used to generate letters
to customers?

We use XL as a database to calculate members' fees. Can
that data be merged into a word document automatically?
We write thousands of these letters annually.

Thanks for the help!
 
If desired, you can do it in Excel without Word. Just have a formula that
refers to the lookup address and a macro that loops thru the names, changes
the formula or the address directly, prints the letter and then does the
next one.
something like
for each member in mylist
[address1]=member
[address2]=member.offset(0,1)
etc
sheets("letter").printout
next
 
Back
Top