You are on the right track. Keep the data in XL and the template in
Word. Then use Word's Mail Merge capability.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
Hi

In Excel I have a customer list showing information in numerous columns e.g.
Name/ Address / Contact info etc. In Word I have created a Label Template
using the information in Excel. I have inserted a Command Button on the User
Form in Excel is it feasible to just Click on the Command Button to open the
Label Template in Word. If its possible what code would I need in the Excel
VBA ????

Any help would be much appreciated.

Cheers------ Mully