[TheDon]

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

[Peter Jamieson]

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

[TheDon]

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
.

[Peter Jamieson]

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
.

[TheDon]

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
.

.

[Peter Jamieson]

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.