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
"Pam Edwards" <pam[ at ]discussions.microsoft.com> wrote in message
news:11461975-075A-4C7F-B197-5BBC2F892A71[ at ]microsoft.com...
[Quoted Text] >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.
|