View Single Post
  #11   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Checkboxes on mailmerge recipients list

The only other suggestion I can make is that if you are using a suitable
dialect of SQL (i.e. one that can do JOINs with something that you are able
to create) then you could build a list of included record numbers and store
it as a file, then do an Inner Join with whatever table/query you are
already using as a data source. Jet/ACE would probably support such a Join
even if the data was stored as (say) a delimited text file, although I
haven't actually tried that in Word. Or alternatively if the list of
included records is small enough that you don't exceed the 255/511 character
limit on qeury length, I suppose you could add

WHERE included_record_in IN (ID1,,ID)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Steffen Grellmann" wrote in message
...
On Fri, 14 Dec 2007 21:54:20 -0000, "Peter Jamieson"
wrote:

Do you know a way to /close/ the Recipients dialog programmatically?


No, unless you can either get sendkeys to work (which I can't, here), or
do
the equivalent of sendkeys using the Win32 API.


I also can't get SendKeys working. Because the recipients dialog is a
popup you can't execute any code until the dialog has been closed. It
doesn't wonder that I had no success when I tried to close the dialog
using the Win API. It might be worth trying to /open/ the dialog using
Win API and to close it immediately again, but I have no idea for the
moment how the dialog could be opened using API.

Kind regards,

Steffen