Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Chicago
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sort (alphabetize) mail merge (2000)

    I used the Merge with Word choice on the OfficeLinks button on the toolbar to create some mailing labels. The query (I queried a table to get the fields I wanted) was not originally sorted by Last Name but, before I did the mail merge, I sorted it and saved it.
    When I do the mail merge, the records do not show in alphabetical order and the sort tab is unavailable when I click the query options button in the mail merge dialog box.
    Is there a way to get my labels to print alphabetically?

    Thanks much!

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sort (alphabetize) mail merge (2000)

    Nancy,

    Make sure you have the sort specified in your query (don't just sort and save the table). Then, as long as you apply the Office Link to the query results (not the table), the merge should progress in the order matching your query's sort criteria. (I tried this with an unsorted table of mine and it worked fine -- I, too, found the sort tab in Word disabled, but the records came through sorted the way I wanted, so I didn't need it.)

    Hope this helps.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Chicago
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sort (alphabetize) mail merge (2000)

    Worked like a charm - thanks!

Posting Permissions

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