Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Link to an Excel data table (Office XP)

    On an Excel sheet, I have a table setup with the following three columns: Employee Name, User Name, Password. There's about 150 rows (or records).

    I've just typed a memo using Word. The purpose of the memo is to let each of the employees know what their personal User Name and Passwords are to the company training website. It's a full page memo with other information about the website, but there are three places on the memo where I have just put "_____________" blanks. It was my intention to print the "stock" memo, make 150 copies and fill in the blanks (using a pen) with information form the Excel data sheet.

    Then I thought, this is a computer <img src=/S/exclamation.gif border=0 alt=exclamation width=15 height=15> There's got to be a better way. Can Word fill in the blanks from the Excel data? I know this exercise is probably a bit involved for full instructions on the lounge but if someone can steer me in the proper direction, I'd be grateful. Maybe, this same type question has already been answered in the lounge?
    - Ricky

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to an Excel data table (Office XP)

    Hi Ricky:
    This sounds like a straight job for mail merge. Go to Tools/Mail Merge... I know the steps have changed slightly since Word 2000, but you can put the old dialog box back, if you prefer. Either way, just select Form Letters as the type of main document & your Excel worksheet as a datasource. Then type your memo & instead of blanks, insert the appopriate mail merge fields. Then just merge to a new document & you have a letter for each employee.

    If you have any specific problems, post back.
    Cheers,

  3. #3
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to an Excel data table (Office XP)

    Ricky

    Mail merge in 2002 has changed quite a lot from previous versions. If you've never done one before - its probably easiest to use the Wizard

    Tools > Letters & Mailings > Mail Merge Wizard ...

    At step 2 - Browse for your Excel sheet

    At step 3 - select your current file

    The only difficult step is to insert fields where you want them. Go to the right place for the first, then select "insert merge fields" - its a button on the mail-merge toolbar, and click the one you want. Repeat for each field. Once you've done that - check it out with a "merge to new document" selection before committing a mistake to a printer.

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Link to an Excel data table (Office XP)

    Thanks to both Andrew and Phil. I went the way of the Wizard! I assumed it would be a complicated undertaking, when actually it took me less than 3 minutes to put the fields in place. The print job is taking a bit longer... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    A very simple, effortless task when you know what to do. Again, I appreciate the direction. You've just saved me several hours.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    - Ricky

Posting Permissions

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