Results 1 to 3 of 3

Thread: Mailmerge? (XP)

  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mailmerge? (XP)

    Not sure if this is a mailmerge question. I have a word document template that I frequently use for the classroom. It has a table designed as I need with the appropriate columns, headings, and column widths. I also have an Excel spreadsheet for my classes - one class per tab containing the student names. I would like to use the Excel file as a data source and merge the students names into my table.. one name per row.

    I seem to be unable to do this - I can merge the data but I end up with one page per student but I need all the names in a table so I can print it and use it in the classroom.

    How would I do this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mailmerge? (XP)

    Option 1:
    Create a table with the desired layout, but only one row.
    In the first step of the Mail Merge wizard (task pane), where you select the document type, select Directory.
    Continue as usual, insert merge fields in the table row as needed, and finally merge to a new document.
    Then insert header row(s) if necessary.

    Option 2:
    Create a table with the desired layout, including header row(s), and with as many rows for students as you need.
    Again. select Directory.
    This time, insert the merge fields in each row, and insert a field { NEXT } after the text in the last cell in each row. Don't type the brackets { } but insert them by pressing Ctrl+F9. Alternatively, click Insert Word Field on the Mail Merge toolbar, and click Next Record.

  3. #3
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mailmerge? (XP)

    Thank you Hans, Option two gives me what I want. Option one produced multiple rows - each as an individual table.

Posting Permissions

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