Use word and mailmerge
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
--
Regards,
Peo Sjoblom
"Denise" wrote in message
...
Worksheet sent to me that I need to print labels for
A1 = I_NAMEP
B1 = I_ADDR1
C1 = I_ADDR2
D1 = I_ADDR3
Column A is full name
Column B is street address
Column C is City, State & Zip
Column D is empty
74 rows with data
Please treat me like a total novice. I'll need the step by step as to how
to enter the macro, how to run it so as to turn the data into labels (30
on a
sheet?)
Gratefully,
Denise