MS Office 2007 question

Discussion in 'OT Technology' started by Joe_Cool, Jan 29, 2010.

  1. Joe_Cool

    Joe_Cool Never trust a woman or a government. Moderator

    Joined:
    Jun 30, 2003
    Messages:
    299,517
    Likes Received:
    619
    I have an excel table with 100 rows, each row containing a record number, a computer serial number, and a user's name.

    I have a word doc that I need to fill out - one copy for each set of record/computer/user data.

    I want to end up with 100 copies of the word doc with the three fields filled out, without having to actually fill out and save-as 100 copies. Is there a way to automate this?
     
  2. NappyTurk

    NappyTurk Banned

    Joined:
    Feb 13, 2008
    Messages:
    643
    Likes Received:
    0
    Location:
    Outer Space
    Mail merge?
     
  3. DAN513

    DAN513 OT Supporter

    Joined:
    Mar 10, 2003
    Messages:
    10,090
    Likes Received:
    2
    Location:
    204
    That's hands down the easiest way to do it.
     
  4. Joe_Cool

    Joe_Cool Never trust a woman or a government. Moderator

    Joined:
    Jun 30, 2003
    Messages:
    299,517
    Likes Received:
    619
    Can you think of any reason why the entire Mailings ribbon would be grayed out?
     
  5. DAN513

    DAN513 OT Supporter

    Joined:
    Mar 10, 2003
    Messages:
    10,090
    Likes Received:
    2
    Location:
    204
    :dunno:

    I just went in, new document, clicked the tab for mailings and then start mail merge, and step by step mail merge wizard.
     
  6. Joe_Cool

    Joe_Cool Never trust a woman or a government. Moderator

    Joined:
    Jun 30, 2003
    Messages:
    299,517
    Likes Received:
    619
    Yeah that works in a new doc, but I have a checklist doc I'm required to fill out. :jerkit:
     
  7. BlazinBlazer Guy

    BlazinBlazer Guy Witness to The De-Evolution of Mankind.

    Joined:
    Jul 24, 2002
    Messages:
    18,783
    Likes Received:
    0
    Location:
    Lansing, MI USA
    So copy/paste the content of the checklist doc into a new Word document (I'm guessing that document you have is a .doc and not a .docx) and then do the mail merge.
     
  8. Joe_Cool

    Joe_Cool Never trust a woman or a government. Moderator

    Joined:
    Jun 30, 2003
    Messages:
    299,517
    Likes Received:
    619
    No, it's a docx.
     
  9. Zak8022

    Zak8022 New Member

    Joined:
    Apr 16, 2004
    Messages:
    4,012
    Likes Received:
    0
    Location:
    Maryland
    Mail Merge should still work in docx. Is it possible there's protection on the doc you are working with? That might hinder mail merge from working properly (just a guess, i'm not positive).
     
  10. OniMinion

    OniMinion ...recalls when this forum was actually about cars OT Supporter

    Joined:
    Jan 26, 2005
    Messages:
    4,894
    Likes Received:
    1
    Location:
    Indiana/Minnesota
    RE "Save As" NOT as DocX... Enjoy.
     

Share This Page