View Single Post
 
Old 04-17-2015, 03:34 AM
Joseph.Comerford@bentley. Joseph.Comerford@bentley. is offline Windows 8 Office 2013
Novice
 
Join Date: Apr 2015
Posts: 1
Joseph.Comerford@bentley. is on a distinguished road
Default 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
Attached Files
File Type: xlsx Excel for Forum.xlsx (10.8 KB, 14 views)
File Type: docx Table for Forum.docx (20.5 KB, 13 views)
Reply With Quote