Hi guys.
Im fairly new to building mailmerge with field codes, and I have come so far as to understand the syntax, however I just cannot get the code to work. Im assuming theres an error that I just cannot spot. Will really appreciate some help on this:
I have a database with the following column headings:
First names, Identity number, Preferred name, Surname, Title, Advisor, Advisor ID number, broker commission, advice type, contract number, product, provider (in that order)
What I need is to use a few of these fields to draw up a record of advice for a client, with all off the clients different investments displaying on one letter (contract number), as well as which company it is invested with and the product type. I do not necessarily need the ID number to display but I am using that as key field. When i do the mailmerge it says :Error, invalid op code.
Here is the code:
(IF(MERGESEQ)=1″
ADVICE RECORD
GOAL OF CLIENT………………………….
TYPE OF ADVICE: FOCUSSED
ID NO: (MERGEFIELD “Identity_number”)
Company Contract number Product
” “”) (SET ID1 (MERGEFIELD “Identity_number))
(IF (ID1)(ID2)”
Advice given will be based on a specific need…..
………..page break………..
ADVICE RECORD
GOAL OF CLIENT………………………….
TYPE OF ADVICE: FOCUSSED
ID NO: (MERGEFIELD “Identity_number”)
Company Contract number Product
(MERGEFIELD “Provider”) (MERGEFIELD “Contract_number”) (MERGEFIELD “Product”)” “(MERGEFIELD “Provider”) (MERGEFIELD “Contract_number”) (MERGEFIELD “Product”)”) (SET ID2 (MERGEFIELD “Identity number”))
Would really appreciate some help if anyone can see my mistake. I can attach a sample if necessary.
Thank you
