Microsoft KB Archive/155029

= PUB97: Mail Merge Filters and Sorts Sometimes Case-Sensitive =

Article ID: 155029

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Publisher 97 Standard Edition

-



This article was previously published under Q155029



SUMMARY
If you use a Microsoft Publisher address list or a Microsoft Access database as the data source for a mail merge, your filtering and sorting will not be case sensitive. If you use a text file, Microsoft Excel worksheet, or most other types of files as a data source, your filtering and sorting WILL be case sensitive.



MORE INFORMATION
"Case sensitive" means that lowercase letters are treated differently from uppercase letters (usually, uppercase A-Z followed by lowercase a-z).

In a non-case sensitive sort, both uppercase and lowercase letters are treated in the same way. For example, if you have a list that includes the elements "Cat," "dog," "apple," and "Bat," and you sort it with a case- sensitive sort, it will be sorted as follows:

Bat

Cat

apple

dog

If you sort the same list with a non-case sensitive sort, it will be sorted like this:

apple

Bat

Cat

dog

Both Microsoft Access and Microsoft Publisher's address list tool create files in the Microsoft Database (.mdb) format. This is the format the Mail Merge database engine uses internally. Databases of other formats are converted. Converted formats are case sensitive, .mdb files are not.

Additional query words: 97 4.0 merging w_mspub mspub pub4 pub97

Keywords: kbinfo kbinterop kbfaq kbusage KB155029

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.