+ Reply to Thread
Results 1 to 3 of 3

Import cells from excel into word and create multiple word docs

  1. #1
    Registered User
    Join Date
    03-20-2006
    Posts
    8

    Import cells from excel into word and create multiple word docs

    Let me first start off by saying hello. I am a long time browser of this board and today I registered.
    I have an excel spreadsheet with student ID numbers and scores for various tests. I have looked at the microsoft templates as well as done an extensive search here and I have not been able to figure this out.
    I want to create a button (or some type of function) in the excel file that will export the student ID and several of the test scores which are in the same row into a word document I have created. I would like to be able to select any student or students and then press the button to fill in the word template with their information and save it as a new document with the student ID as the name.
    I do not know how to set this up.
    I use excel almost every day but I have very little experience with macros.
    Any help as to which direction to head with this would be much appreciated.

    -Chad

  2. #2
    Carim
    Guest

    Re: Import cells from excel into word and create multiple word docs

    Hi Chad,

    It is more of a Word issue ...
    Indeed, If you take a look at the MailMerge function in Word, you will
    be able to have your excel spreadsheet acting as the reference database
    ....

    HTH
    Cheers
    Carim


  3. #3
    Registered User
    Join Date
    03-20-2006
    Posts
    8
    Thanks, the solution was much easier than expected.

    I appreciate it.

    -Chad

+ 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