Creating a table in one document of WORD from EXCEL with Mail Merge
Hi,
I am trying to take a simple excel file and create a table in a single word document when I run a directory Mail Merge.
I am trying to use the code
{IF { MERGESEQ } = "1" "{ MERGEFIELD «Payer»}" "" }<ENTER>
{ SET Place1 { MERGEFIELD «Payer»}}<ENTER>
{ If { Place2 } <> { Place1 }"<ENTER>
{ MERGEFIELD «Payer»}<ENTER>
<ENTER>
{ MERGEFIELD «Invoice»}{ MERGEFIELD «Due_Date»}{ MERGEFIELD «Curr»}{ MERGEFIELD «Local_Amt» }"
Although it does not appear to be working correctly.
Is this possible to do?
How can I do this?
I have attached the very simple WORD and EXCEL file and would appreciate if anyone could help me make this happen.
Thanks
|