Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
James James is offline
external usenet poster
 
Posts: 113
Default MailMerge only pulls first record from SQL table when filtered

Software versions:

Word 2007
SQL 2005
Access 2007

Issue: When I attempt to do a mailmerge from within Word when linking back
to a basic table in SQL or Access and I attempt to filter on a particular
field (ie InvoiceNumber), it will only choose the very first record of the
table if there are just 10 records or thousands in it. I've not only tried
setting the filter so that the InvoiceNumber equaled the number but I've also
tried using a compound filter where the InvoiceNumber 4 and InvoiceNumber
6 in order for it to select invoice number 5 and that didn't work either, it
would simply pull the first record, no matter what the InvoiceNumber was.

I've found scattered posts on Google about this particular issue with Word
2003 and 2007 and MailMerge but none of the solutions worked. Has anyone
else seen this before and if so, what did you do to fix it?

Thanks for your help!

James
 
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
inserting the DATABASE field in a mailmerge with filtered reults Rich Mailmerge 11 September 24th 09 11:53 PM
Mailmerge: First Record in stead of Next Record Guus Mailmerge 6 February 6th 07 04:00 PM
Mailmerge only merges picture from 1st record, can anyone help? Thulo Shrestha Mailmerge 1 April 7th 06 06:01 AM
Mailmerge Next record John T Mailmerge 1 March 2nd 06 01:10 PM
Mailmerge always grabs the first record in Access table Darshan Khalsa Mailmerge 1 January 3rd 06 08:18 PM


All times are GMT +1. The time now is 11:41 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"