Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Sep 2004
    Location
    St. Louis, Missouri, USA
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    elminating duplicates (Office 2003 Windows XP)

    Hi,

    Is there a way, when using Excel as the data source for a Word mail merge to tell it you only want one letter per person. In other words, I have a worksheet with hundreds of students, several of whom are taught by the same teacher. If I want to send something only one time to each teacher, how can I do that?

    Thanks

    Lana

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: elminating duplicates (Office 2003 Windows XP)

    You could use Excel's Advanced filter to select unique records, then use the filtered list as the source in the mailmerge.
    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Sep 2004
    Location
    St. Louis, Missouri, USA
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: elminating duplicates (Office 2003 Windows XP)

    Well, again you saved the day. I did end up copying the filtered data into a new file so I could mail merge it - was this a necessary step? I, obviously am not too familiar with Excel - typically use Access for my own work. Thank you again.

    Lana

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: elminating duplicates (Office 2003 Windows XP)

    I don't think that was necessary, but I don't know enough about Word to tell you for sure.
    Legare Coleman

Posting Permissions

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