Reply
 
Thread Tools Display Modes
  #1   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?

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


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Is there a way to sort the DB fields in Word's mailmerge field lists?

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



  #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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort by multiple fields Kevin Sink Mailmerge 1 September 15th 06 08:45 PM
word mailmerge field sort jonnyb Mailmerge 5 March 28th 06 11:53 AM
Why does Word sort my lists incorrectly? -mike- New Users 6 October 3rd 05 01:40 AM
How to add optional address field into middle of Word's preformat. Eric Mailmerge 2 February 10th 05 06:18 AM
MS Word's Insert -> Fields-> TC Problem Bruce A. Julseth New Users 1 January 5th 05 03:56 PM


All times are GMT +1. The time now is 05:05 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"