Replies

Ahh, I was trying “Does not equal”, which doesn’t seem to work although one would have thought it should.

Now is it possible to perform this filter using Advanced Filter”?
(The ultimate filter criteria will require the use of advanced filter)

Silly me I meant to write ‘0321

Thank you Hans, you’re a star (of course if word recorded the steps properly then I wouldn’t have had to ask you!!!)

I tried recording the setting of a Merge filter, so that I could geta clue as to the VBA code required to automate it. But the subroutine produced contained no code at all.

Where do I find the classes/methods/properties associated with this and get a clue as to the correct construction?

TIA
Paul

When I try DDE I get the error “Word could not parse your query options into a valid SQL string.” and it then simply ignores the filter and reads all the data.

However the ODBC option seems to work.

Obviously a bug in Word with OLE DB somewhere.

Thanks for your assistance.

Thank you Hans, this is very much appreciated.

Maybe you can send me your working examples and I’ll try working in the other direction?

Hello Hans,
thank you for looking at my problem.

The attached zip file should be unpacked in the root directory of the C drive. It will then re-create the original directory structure which I created for this test and which is very simlar to the structure that I actually use.

When unpacked you will find in the directory C:$user1HSCPool two Word files and one Excel file.

Both the Word files were linked to the Excel file when they were saved.

Pool Log Mail Merge Man2s.doc is a “simple” SQL query whilst Pool Log Mail Merge Man2w.doc contains the WHERE clause.

When I open Pool Log Mail Merge Man2s.doc, it is ready to go. When I open Pool Log Mail Merge Man2w.doc I have to go and re-link it to the database (the Excel file).

Thanks once again for taking a look at this.

TIA

Thanks Has, smashing news.

Yeah, that’s what I did this time. I’m just confused as to why the other thing doesn’t work (and now that you have mentioned it, why the Select All button is there at all if it is always unavailable).

That button is always disabled for me too (anyone know why it is there?).

But I used (l;ast week, to be able to right click a style and select all instances of that style in the document. Then I could just click on a new style and all the instances would change to use this new style.

I KNOW that only last week I was able to use this feature to select all instances of a particular style.

Hmmm,
I just decided to change them all back to the original styles, but for some strange reason, the option to select all of any style is greyed out and says Not curretnly Used. this is true for every style in the document.

Any idea why I can no longer use this function?

Smashing Hans, that is just the setting that I was looking for!

No I can dump those extra styles.

Thanks a million.

Thanks Karen, I will do but it’ll most likely take a couple of days as we have Easter Holidays here at the moment.

Sorry for the delay but I’ve been at CEBIT in Hanover for the last couple of days.

The URL was posted in the first post. It is http://www.stjamesmilton.net

However you can see the error just by taking the complete block of HTML that I posted and writing it to a .HTM page on your own PC and then opening it in IE.

The same HTML is used to redirect to other sites (albeit with different URLs) and it does not produce the error.

For example try http://www.isleofwightwines.co.uk

So we have

http://www.isleofwightwines.co.uk redirect to perksofventnor.co.uk OK
direct access to stjamesmilton.port5.com OK
http://www.stjamesmilton.net redirect to stjamesmilton.port5.com Page loads but with errors reported

Well I altered the ratios to 90/10 but I didn’t see anything different?

What should I have been looking for?