Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can't Filter in Mail Merge Recipients
The Mail Merge Recipients box will not sort or filter. I think it has
something to do with the master document not being saved but I do'nt remember what to do. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can't Filter in Mail Merge Recipients
Which version of Word? What is the data source?
something to do with the master document not being saved but I do'nt remember Do you mean the "Mail Merge Main Document" (i.e. your "layout") or something else? What if you /do/ save your "master document" (it seems an obvious thing to try!) -- Peter Jamieson http://tips.pjmsn.me.uk "maclop" wrote in message news The Mail Merge Recipients box will not sort or filter. I think it has something to do with the master document not being saved but I do'nt remember what to do. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can't Filter in Mail Merge Recipients
Hi Peter, Sorry for leaving out key information.....it is office 2003 and the
data source is an excel spread sheet "Peter Jamieson" wrote: Which version of Word? What is the data source? something to do with the master document not being saved but I do'nt remember Do you mean the "Mail Merge Main Document" (i.e. your "layout") or something else? What if you /do/ save your "master document" (it seems an obvious thing to try!) -- Peter Jamieson http://tips.pjmsn.me.uk "maclop" wrote in message news The Mail Merge Recipients box will not sort or filter. I think it has something to do with the master document not being saved but I do'nt remember what to do. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can't Filter in Mail Merge Recipients
There can be a problem if you connect using ODBC. If you do that,
a. you can't filter in the Edit Recpients dialog box, although you can sort b. in that dialog, if you select one of the drop-down arrows in a column header, then Advanced... you may see a message along the lines of "Word detected Microsoft Query on your system. Would you like to edit your data source name using Microsoft Query?" If you say No, Word's "Query Options" dialog opens and you should be able to specify filters in there. If you say Yes, you are plunged into MS Query. However, by default, Word 2003 does not connect to Excel via ODBC - it uses OLE DB. To connect using ODBC, a. either the document was already set up that way, b. or you chose ODBC in the additional "Confirm Data Source" dialog that pops up when you select a data source if that option is selected in Word Tools|Options|General, c. or you connected via MS Query d. or Word failed to connect using OLE DB, in which case it tries to use ODBC instead, e. (or perhaps another route I do not know of) Your best bet in cases (a) to (c) is probably to connect via OLE DB (or DDE) and try again. Otherwise, I'm not sure what is going wrong, but I would try a very simple test with feshly created Excel and Word test documents to see if you always get the problem, or only sometimes. -- Peter Jamieson http://tips.pjmsn.me.uk "maclop" wrote in message ... Hi Peter, Sorry for leaving out key information.....it is office 2003 and the data source is an excel spread sheet "Peter Jamieson" wrote: Which version of Word? What is the data source? something to do with the master document not being saved but I do'nt remember Do you mean the "Mail Merge Main Document" (i.e. your "layout") or something else? What if you /do/ save your "master document" (it seems an obvious thing to try!) -- Peter Jamieson http://tips.pjmsn.me.uk "maclop" wrote in message news The Mail Merge Recipients box will not sort or filter. I think it has something to do with the master document not being saved but I do'nt remember what to do. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter & Sort icon shortcut on mail merge toolbar for Mail Mer Rec | Mailmerge | |||
Problems Filter recipients in Word merge vs building Query in Acce | Mailmerge | |||
mail merge FILTER | Mailmerge | |||
Mail merge filter | Mailmerge | |||
Mail merge filter | Microsoft Word Help |