Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Creating an invoice with mail merge (2007)
Hello,
Who can help me with this: I have an Excel file with the following fields: invoice no, client name, address etc., article no, article description, price All records of all clients are collected in the Excel file. So for p.e. invoice no. A100 there are 5 records, because there are 5 articles. Next there are 2 records for invoice A101, because there are 2 articles for the invoice. The Excel file is an export file from a different program and the new records are appended to the existinig ones. I want to make an invoice in Word 2007 mail merge. The client data should be printed once at the top of the invoice and the acticle lines should be printed as long as they are part of invoice no # It would be nice if the end user could choose which invoice he wants to print at the beginning of the mail merge. (Using a field that "stores" the invoice number and then compare each record with this number??? Or a bookmark?) Has anybody ever created something like this? Do I need a macro? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
increment invoice number within mail merge | Mailmerge | |||
Creating an invoice template | Page Layout | |||
Invoice Mail Merge with Master Detail Information | Mailmerge | |||
creating invoice from template | Microsoft Word Help | |||
Creating an Invoice with Mail Merge | Mailmerge |