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.
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.