Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Brian Smither
 
Posts: n/a
Default Excluded Records Anomaly

A recent mail merge resulted in a Catalog (using Word 2003, so a Directory)
with random missing records. I believe I know what happened. It's a gotcha
that one would need to be aware of.

Using the Mail Merge Wizard, I setup a merge operation knowing that the
Access table had invalid records that would be printed in the Directory. At
one phase in the Wizard, one is given the opportunity to exclude records by
unchecking a box.

Later, I realized I needed to sort these records. (And one has to go
through the whole process of re-connecting to the database in order to get
at the sort mechanism.)

Now, the Dirctory was including the invalid records and dropping random (or
so it seemed) valid records.

Without any rigorous experimentation, it appears that Word 2003 is
remembering the excluded record positions across re-connections, so that
when the newly retrieved recordset is sorted, different records are
excluded than what were excluded earlier - based on record position, not
primary key index values (if present).

Can I get a corroborating experiment on this?

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot edit Access records from Word mail merge toolbar button Snazbaz Mailmerge 2 January 24th 06 07:17 PM
mailmerge from Access parameter query only merges odd records helios Mailmerge 5 December 30th 05 11:24 AM
order that records are returned Marty New Users 0 September 8th 05 02:02 PM
First Record's Letter Missing after Letter Merge TS in FL Mailmerge 3 June 8th 05 01:15 PM
Multiple records into a single document Mark Mailmerge 5 March 22nd 05 07:52 PM


All times are GMT +1. The time now is 02:58 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"