|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 30th, 2009, 03:01 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge filter Toubleshoot
When I filter items in MS Word using mailmerge, I seem to get fitlering
errors where word adds, duplicates or changes the filters unexpectedly. Any ideas? Background: Currently using Office 2007; this was also happening in 2003. Datasource is Access database (2002-2003 format), running on a peer to peer network. All shares are on a stan alone peer/server. thanks, Don 
|
|
#2
November 30th, 2009, 06:47 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge filter Toubleshoot
There are a number of different problems with the filtering in Mail
merge, but the main longstanding one is to do with filters that try to include/exclude blank fields - e.g., see http://support.microsoft.com/kb/286880 If that's what you are experiencing, by all means see if the article helps but otherwise another fix may be possible. Peter Jamieson http://tips.pjmsn.me.uk On 30/11/2009 15:01, TheDon wrote: When I filter items in MS Word using mailmerge, I seem to get fitlering errors where word adds, duplicates or changes the filters unexpectedly. Any ideas? Background: Currently using Office 2007; this was also happening in 2003. Datasource is Access database (2002-2003 format), running on a peer to peer network. All shares are on a stan alone peer/server. thanks, Don
|
|
#3
December 3rd, 2009, 10:14 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge filter Toubleshoot
The article was not terribly helpful. It might help if I do not want to use
a filter at all... So the premise here is try to avoid "is Null" or as Word puts it "is blank" in my filter criteria? Let me know if there is any additional workaround. thanks for the help... "Peter Jamieson" wrote: There are a number of different problems with the filtering in Mail merge, but the main longstanding one is to do with filters that try to include/exclude blank fields - e.g., see http://support.microsoft.com/kb/286880 If that's what you are experiencing, by all means see if the article helps but otherwise another fix may be possible. Peter Jamieson http://tips.pjmsn.me.uk On 30/11/2009 15:01, TheDon wrote: When I filter items in MS Word using mailmerge, I seem to get fitlering errors where word adds, duplicates or changes the filters unexpectedly. Any ideas? Background: Currently using Office 2007; this was also happening in 2003. Datasource is Access database (2002-2003 format), running on a peer to peer network. All shares are on a stan alone peer/server. thanks, Don .
|
|
#4
December 4th, 2009, 12:06 AM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge filter Toubleshoot
Can you tell us a bit more about the specific filtering problems you are
having? a. Is it to do with nulls/blanks? b. can you use the Word VBA Editor immediate window to display the value of the SQL Word is actually sending to Access, e.g. using ?ActiveDocument.MailMerge.DataSource.Querystring (I would guess that the query string is changing each time you merge, or change the criteria, in which case it would be helpful to show more than one value of .Querystring) Peter Jamieson http://tips.pjmsn.me.uk On 03/12/2009 22:14, TheDon wrote: The article was not terribly helpful. It might help if I do not want to use a filter at all... So the premise here is try to avoid "is Null" or as Word puts it "is blank" in my filter criteria? Let me know if there is any additional workaround. thanks for the help... "Peter Jamieson" wrote: There are a number of different problems with the filtering in Mail merge, but the main longstanding one is to do with filters that try to include/exclude blank fields - e.g., see http://support.microsoft.com/kb/286880 If that's what you are experiencing, by all means see if the article helps but otherwise another fix may be possible. Peter Jamieson http://tips.pjmsn.me.uk On 30/11/2009 15:01, TheDon wrote: When I filter items in MS Word using mailmerge, I seem to get fitlering errors where word adds, duplicates or changes the filters unexpectedly. Any ideas? Background: Currently using Office 2007; this was also happening in 2003. Datasource is Access database (2002-2003 format), running on a peer to peer network. All shares are on a stan alone peer/server. thanks, Don .
|
|
#5
December 8th, 2009, 08:42 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge filter Toubleshoot
a. It usually has to do with the "is blank" or "is not blank" in Word
b. I went into the VBA editor, but I didn't see ay sql string or the such. Let me know if I am doing that correclty. In 2007, I hit Developer/Visual Basic/ then selected the surrent document and viewed the immediate window, it was blank. I'm not sure I am in the right place. "Peter Jamieson" wrote: Can you tell us a bit more about the specific filtering problems you are having? a. Is it to do with nulls/blanks? b. can you use the Word VBA Editor immediate window to display the value of the SQL Word is actually sending to Access, e.g. using ?ActiveDocument.MailMerge.DataSource.Querystring (I would guess that the query string is changing each time you merge, or change the criteria, in which case it would be helpful to show more than one value of .Querystring) Peter Jamieson http://tips.pjmsn.me.uk On 03/12/2009 22:14, TheDon wrote: The article was not terribly helpful. It might help if I do not want to use a filter at all... So the premise here is try to avoid "is Null" or as Word puts it "is blank" in my filter criteria? Let me know if there is any additional workaround. thanks for the help... "Peter Jamieson" wrote: There are a number of different problems with the filtering in Mail merge, but the main longstanding one is to do with filters that try to include/exclude blank fields - e.g., see http://support.microsoft.com/kb/286880 If that's what you are experiencing, by all means see if the article helps but otherwise another fix may be possible. Peter Jamieson http://tips.pjmsn.me.uk On 30/11/2009 15:01, TheDon wrote: When I filter items in MS Word using mailmerge, I seem to get fitlering errors where word adds, duplicates or changes the filters unexpectedly. Any ideas? Background: Currently using Office 2007; this was also happening in 2003. Datasource is Access database (2002-2003 format), running on a peer to peer network. All shares are on a stan alone peer/server. thanks, Don . .
|
|
#6
December 8th, 2009, 10:23 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge filter Toubleshoot
b. I went into the VBA editor, but I didn't see ay sql string or the such. Let me know if I am doing that correclty. In 2007, I hit Developer/Visual Basic/ then selected the surrent document and viewed the immediate window, it was blank. I'm not sure I am in the right place. You are in the right place, but you need to type the following in that Immediate window, then press the enter key to execute the statement. ?ActiveDocument.MailMerge.DataSource.Querystring Peter Jamieson http://tips.pjmsn.me.uk On 08/12/2009 20:42, TheDon wrote: b. I went into the VBA editor, but I didn't see ay sql string or the such. Let me know if I am doing that correclty. In 2007, I hit Developer/Visual Basic/ then selected the surrent document and viewed the immediate window, it was blank. I'm not sure I am in the right place.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
