Is there a way to sort the DB fields in Word's mailmerge field lists?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Clive - 13 Mar 2007 21:18 GMT

I have written an app for my customer that helps them create Word Template
documents, but they have a choice of 30 or so fields - which makes it
tedious to look through it to find the one they want. Is there any way to
sort that list? (Other than rewriting my query!)

Help much appreacited

Clive

Reply to this Message

Peter Jamieson - 13 Mar 2007 21:39 GMT

I don't think you can sort the content of the standard dropdowns. However, I
suppose you could always write your own dialog box that allowed them to pick
the field names, insert the appropriate MERGEFIELD field, and let them sort
in a variety of ways. Not really my thing, particularly because I don't
really like modifying the standard Word user interface.

Peter Jamieson

>I have written an app for my customer that helps them create Word Template
>documents, but they have a choice of 30 or so fields - which makes it
[quoted text clipped - 4 lines]
>
> Clive

Reply to this Message

Clive - 14 Mar 2007 12:14 GMT

Thanks again Peter.

I'd rather not modify the Word UI either. In the end I may do it in SQL - getting the list of fields then sorting them, then programmatically writing a select statement (with sorted fields) - to select from the underlying select statement. Then Word's list will be naturally sorted.

Also thanks for pointing me to the MergeWithAttachments article. That has given a few ideas..

Regards

Clive

>I don't think you can sort the content of the standard dropdowns. However, I
> suppose you could always write your own dialog box that allowed them to pick
[quoted text clipped - 11 lines]
>>
>> Clive

Reply to this Message