Hi All

Thanks for the help - I understand and I can handle it that way - what I was
trying to do was make it user friendly for everybody to use - by just
clicking on say a Labels Command Button in the Excel User Form and then it
would auto to the Labels Template in Word and they can just click print in
Word and - voila 250 Labels up and printed.

Thanks again

Cheers ----- Mully

"Tushar Mehta" wrote:

> 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 <B2FEA76B-CB79-45E8-860A-3AD844DD8284@microsoft.com>,
> mully@discussions.microsoft.com 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
> >
> >
> >
>