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

[Doug Robbins - Word MVP]

Did you use Ctrl+F9 to insert each of the field delimiters { }. Under
ToolsOptionsPrint, 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/show...?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

"Pam Edwards" wrote in message
...
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.