+ Reply to Thread
Results 1 to 8 of 8

pls help me in copy data from excel to word

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    austria
    MS-Off Ver
    Excel 2010
    Posts
    4

    pls help me in copy data from excel to word

    first i'm new user for excel 2010 i need to copy many names (about 5000 name in many cells in excel format ) to 5000 card name in word file .

    i need to put each name from excel file to each card name in (name place) one by one automatic or what ever way to do that.

    with normal way copy and paste one by one will take big time and more effort.

    i know from frined we have a way to do it in one step but he did't know and me i don't know how to do it with macro or otherwise???


    please help me to do this.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: pls help me in copy data from excel to word

    Perhaps something like Word's Mail Merge feature?

  3. #3
    Registered User
    Join Date
    04-25-2013
    Location
    austria
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: pls help me in copy data from excel to word

    no but i need any way to solve this problem

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: pls help me in copy data from excel to word

    I don't understand your answer

  5. #5
    Registered User
    Join Date
    04-25-2013
    Location
    austria
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: pls help me in copy data from excel to word

    sorry for may bad english

    i need to copy this names to many (id cards)
    i have id card form in word file
    i need to copy this names from excel file to name place in id cards -- 5000 name for 5000 cards

    like this

    name 1 : adam adam ---- to name place in card 1
    name 2 : kriste ---- to name place in card 2
    name no 5000 to card no 5000

    in my excel file i already have 5000 names.
    in may word file i have only one id card form.
    Last edited by speedmax; 04-25-2013 at 10:08 AM.

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: pls help me in copy data from excel to word

    Again, have a look at the Mail Merge tool in Word - Using a template and linking it to your excel range will do the trick

  7. #7
    Registered User
    Join Date
    04-25-2013
    Location
    austria
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: pls help me in copy data from excel to word

    i will try and answer u later

    thanks for u time

  8. #8
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: pls help me in copy data from excel to word

    Word's label mailmerge tools are designed specifically for what you're trying to achieve. See:
    http://office.microsoft.com/en-us/wo...001034920.aspx
    http://office.microsoft.com/en-us/wo...101854798.aspx
    http://support.microsoft.com/kb/294684
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1