Results 1 to 2 of 2

Copying Excel Cells Into Word Doc

Threaded View

  1. #1
    Registered User
    Join Date
    05-27-2008
    Posts
    28

    Copying Excel Cells Into Word Doc

    Hello,

    I'm working on a project where I have an excel sheet that has a list of people with information about each person in columns and I need to put each person's data into a specific location on multiple word documents, each document unique to the person. So basically one row is one person and all the columns specific to that person get transferred to a word doc, the doc would get saved, a new one would be opened and the next row in the excel doc would get copied over, etc.. I'm using bookmarks on the word doc as references in my vba doc right now. So far I've gotten one row's worth of information to transfer to a word doc but I don't know how to make it save, open a new one then repeat on the second row. Seems like I would need a loop of some sort. Any help would be appreciated.

    My current docs are attached, the word doc I actually made into a template, which I though might help with the saving multiple copies, but the forum won't let me attached a doc template.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying range of cells to a bookmark in word
    By wonderdunder in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2010, 05:12 AM
  2. Copying tables from Word to Excel
    By antanas26 in forum Excel General
    Replies: 0
    Last Post: 07-09-2010, 04:00 AM
  3. Copying from Word doc into excel spreadsheet.
    By CJPHX in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2010, 12:45 PM
  4. Copying excel to word
    By philmetz in forum Excel General
    Replies: 1
    Last Post: 08-31-2009, 05:05 AM
  5. Copying Excel Buttons to MS Word
    By vioravis in forum Excel General
    Replies: 1
    Last Post: 07-24-2007, 12:47 PM

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