Creating a table in one document of WORD from EXCEL with Mail Merge

Joseph.Comerford@bentley. · #1 04-17-2015, 03:34 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge in Word: creating a rule for blanks	cgranada	Mail Merge	6	02-27-2017 09:08 AM
Creating Barcode Badges using Microsoft Word Mail Merge 2013	Sarah15	Mail Merge	4	04-16-2015 06:03 AM
Merge From Excel With Table in Word - Next Record If Excel Column Same?	misscrf	Mail Merge	2	10-15-2014 11:51 PM
Mail merge table from Excel to Word	krezumica	Mail Merge	2	03-06-2014 10:26 PM
Insert formatted table into word (mail merge)	manojbmsce	Mail Merge	0	09-25-2008 02:25 AM