Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Darshan Khalsa
 
Posts: n/a
Default Mailmerge always grabs the first record in Access table

With Microsoft Word 2003 and Access 2003, when mailmerging a Word document
that contains simple data fields and some query criteria selected, if there
are for example 3 Access records meet the criteria, then the resulting merged
Word document includes the first record in the Access database (instead of
the first record that meets the query criteria) and the second and third
records in the Access database that do meet the query criteria. This seems to
be a bug in Word's mailmerge process not mentioned in the Microsoft Knowledge
Base.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Mailmerge always grabs the first record in Access table

Use an Access Query to select the records that you want to merge and as the
datasource for the mailmerge.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Darshan Khalsa" Darshan wrote in message
...
With Microsoft Word 2003 and Access 2003, when mailmerging a Word document
that contains simple data fields and some query criteria selected, if
there
are for example 3 Access records meet the criteria, then the resulting
merged
Word document includes the first record in the Access database (instead of
the first record that meets the query criteria) and the second and third
records in the Access database that do meet the query criteria. This seems
to
be a bug in Word's mailmerge process not mentioned in the Microsoft
Knowledge
Base.



Reply
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
Word Mailmerge with Access via DDE Jim Gilligan Mailmerge 0 November 22nd 05 02:21 PM
Mailmerge Query - Works in Access; fails in Word Gary Stark Mailmerge 4 October 6th 05 07:57 PM
Trying to suppress Select Table box in Excel-Word mailmerge Denise Mailmerge 4 June 21st 05 01:08 PM
Table AutoFormats vs. Table Styles confusion Tony Jollans Tables 5 March 6th 05 08:18 PM
Mailmerge Access record duplication problem..Deadline Help ASAP Pl Paul Mailmerge 1 February 15th 05 12:12 AM


All times are GMT +1. The time now is 02:23 AM.

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"