Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple Records from Access Query
I am creating a MailMerge letter using data from a query in Access. I would
like the letter to show the [InvoiceNumber] and I[nvoiceAmount] from several records in Access for the same [Vendor], all in one letter. I am getting multiple letters, with one record in each. This is what I've tried, but it's not working. Any ideas? (IF(MERGESEQ)="1" "(MERGEFIELD Vendor)" "") (SET Vendor1(MERGEFIELD Vendor)) (IF (Vendor2)(Vendor1)" (MERGEFIELD Vendor) (MERGEFIELD InvoiceNumber)(MERGEFIELD AmountInvoiced)" "(MERGEFIELD InvoiceNumber)(MERGEFIELD AmountInvoiced)""(MERGEFIELD InvoiceNumber)(MERGEFIELD AmountInvoiced)"(MERGEFIELD InvoiceNumber)(MERGEFIELD AmountInvoiced))(SET Vendor2(MERGEFIELD Vendor)) Note - the () are really the squiggly brackets. As an aside: All of the vendors are the same for the records - so I think there is some extra code in there, but I modified this from somewhere else, and haven't figured out what to get rid of, but I don't think that matters, since the [Vendor] info is the same for all records. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Records Missing from Access Query | Mailmerge | |||
mailmerge MS Access multiple records | Mailmerge | |||
How do I include multiple records per label on Access or Word? | Mailmerge | |||
mailmerge from Access parameter query only merges odd records | Mailmerge | |||
Word 2003 receives no records from Access 2003 query | Mailmerge |