MS Word SQL Server Merge Document

Posted on 2007-08-02
Last Modified: 2010-03-19
I have a MS Word 2003 document that is calling merged data from SQL Server
I need to change the sort on it to order by field1 asc, field2 desc

The popup only allws single sorting
The View in SQL Server is sorted, but ignored in load.

Question by:lrbrister
    1 Comment
    LVL 92

    Accepted Solution

    lrbrister said:
    >>The popup only allws single sorting

    I just tried this in Word 2003.

    1) In the MailMerge wizard I selected SQL Server as the data source, and I picked my table
    2) In the "pick recipients" stage, under the filtering dropdown I selected Advanced.  On the
    Filter and Sort dialog, you can sort on up to three columns.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now