locked
Mail Merge for Category List RRS feed

  • Question

  • I am not able to retain the information I am pulling into my mail merge using the code below.  My goal is to have one letter for each customer displaying specific products with their price.  My source list is in Excel and contains all the information I need...customer number, name and address for each letter, along with Product #, Product Description and Product Price.  I need a page break after each customer, so the customer # is my key field.  Looking at the instructions on the support.microsoft.com seems straight forward, but again, I lose the information when completing the mail merge.  Any help is greatly appreciated...I really don't want to do this manually.

    THank you!!!

    Code:

    { IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }
    " "" }{ SET Place1 { MERGEFIELD CITY }}
    { If { Place2 } <> { Place1 }
    { MERGEFIELD CITY }

    { MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}

    Wednesday, May 29, 2013 1:56 PM

Answers