Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
lion lion is offline
external usenet poster
 
Posts: 5
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
increment invoice number within mail merge Nick_F Mailmerge 3 October 9th 09 09:43 AM
Creating an invoice template Mike P Page Layout 3 May 2nd 07 07:47 AM
Invoice Mail Merge with Master Detail Information Philip L Jackson Mailmerge 1 July 8th 06 08:45 AM
creating invoice from template donkeyminga Microsoft Word Help 2 March 31st 06 04:55 PM
Creating an Invoice with Mail Merge Robert Jones Mailmerge 1 February 4th 05 10:18 AM


All times are GMT +1. The time now is 05:51 PM.

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"