View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Clive Clive is offline
external usenet poster
 
Posts: 7
Default Is there a way to sort the DB fields in Word's mailmerge field lists?

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


"Peter Jamieson" wrote in message ...
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
"Clive" wrote in message
...
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