merge more than one line

P

Pam Edwards

I am trying to merge from excel a list of invoices to each customer. I have
come up with a formula but it is not working, and it prints on the letter
instead of the data. What am I doing wrong.
ORDER PO INVOICE DATE amount
01469 4500263177 255446 8/21/2007 0

{IF {MERGESEQ} = “1†“{MERGEFIELD CustomerNum}†“â€}
{SET Place 1 {MERGEFIELD CustomerNum}}
{IF {Place2} <> {Place1}â€
{MERGEFIELD CustomerNum}
{MERGEFIELD OrderNum}{MERGEFIELD PONum}{MERGEFIELD InvoiceNum}{MERGEFIELD
InvoiceDate}{MERGEFIELD AmountDue}â€â€{MERGEFIELD OrderNum}{MERGEFIELD
PONum}{MERGEFIELD InvoiceNum}{MERGEFIELD InvoiceDate}{MERGEFIELD
AmountDue}{SET Place2 {MERGEFIELD CustomerNum}}

{If {MERGESEQ} = “1â€â€{MERGEFIELD CustomerNum}â€â€â€}
{SET Place 1 {MERGEFIELD CustomerNum}}
{If {Place2} <> {Place1}â€


The customer number is up further on the page of the letter and on the Excel
file. The Excel file is sorted in customer order so all the invoices are
together.
 
D

Doug Robbins - Word MVP

Did you use Ctrl+F9 to insert each of the field delimiters { }. Under
Tools>Options>Print, do you have a check mark in the Field codes box under
the Include with Document section of the dailog.

Take a look at:
http://cornell.veplan.net/article.aspx?&a=3815

or fellow MVP, macropod's tutorial on Catalogue/Directory Mailmerges at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top