User Form Problem ???

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

Hi Mully
My logic tells me you should do this from Word

"mully" wrote:

> 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
>
>

Hi Kassie

Thanks I'll go on the Word New Users and see if somebody can help.

Thanks again

Cheers Mully

"Kassie" wrote:

> Hi Mully
> My logic tells me you should do this from Word
>
> "mully" wrote:
>
> > 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
> >
> >

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
>
>
>

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
> >
> >
> >
>