More than 6 query options

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DMSPaul - 19 Nov 2004 08:24 GMT

Hi, I have a few word documents that all merge with an exce
spreadsheet, this spreadsheet contains some 1000+ addresses and change
every day.
I use query options/filter records to select the data I want from th
spreadsheet and this all works fine.
However some of my letters require very complicated query options and
have just now encountered one that requires more than the 6 available t
me, is there any way to add more or to get around this?
Editing the data manually is unfortunately not an option.
I am using Office 2000.

Thanks for any help you can give.

Pau

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Doug Robbins - 20 Nov 2004 12:05 GMT

If you have Access, move the data into it and then use it's Querying
capabilities. Data manipulation is best done by database programs not
spreadsheets.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Hi, I have a few word documents that all merge with an excel
> spreadsheet, this spreadsheet contains some 1000+ addresses and changes
[quoted text clipped - 13 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message