Results 1 to 2 of 2

Thread: Mail Merge

  1. #1
    New Lounger
    Join Date
    Nov 2009
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I am trying to do a mail merge from an excel file. I have multiple employees with multiple stock options that have numbers assigned to them. The data is sorted on the excel spreadsheet so that each line has the employee name in one column with a option number in the next column. So, for example, if an employee has 6 options, their name is listed 6 times, with a particular option number assigned to it. When I do my mail merge, I am getting 6 separate sheets for this employee, each with the 1 option number on it. Instead I want 1 sheet with all of the options listed for that particular employee, then proceed to the next employee and have only their information on the sheet. I've been working on this for awhile now. Any idea what I am doing wrong?

    Thanks,

    DAC

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    This thread about catalog merges might help: [topic=731107]Word 97-2007 Mailmerge Tutorial: Create Sorted Listings (v1.52)[/topic].

Posting Permissions

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