Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting the DATABASE field in a mailmerge with filtered reults | Mailmerge | |||
Mailmerge: First Record in stead of Next Record | Mailmerge | |||
Mailmerge only merges picture from 1st record, can anyone help? | Mailmerge | |||
Mailmerge Next record | Mailmerge | |||
Mailmerge always grabs the first record in Access table | Mailmerge |