View Single Post
  #12   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Steffen Grellmann Steffen Grellmann is offline
external usenet poster
 
Posts: 7
Default Checkboxes on mailmerge recipients list

On Sat, 15 Dec 2007 18:12:32 -0000, "Peter Jamieson"
wrote:

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.


Thank you Peter, this is another nice idea. I will think about it.
It's a bit pity that with this solution the checkstate would not be
consistent beetween Word's recipients list and my own list. It was my
goal to make this consistency sure at any time. But if you know this
approach is not that easy as to say (e.g.the filters...).

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)


Before I started this thread, I first thought Word is doing it
internally this way. But I cannot use WHERE because I'm at the 255/511
character limit right now and the amount of possible records is too
much.

Kind regards,

Steffen