If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
merge more than one line
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. |
#2
|
|||
|
|||
merge more than one line
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. |
Thread Tools | |
Display Modes | |
|
|