Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

LinkBack Thread Tools Display Modes
Old 04-17-2015, 03:34 AM
Joseph.Comerford@bentley. Joseph.Comerford@bentley. is offline Windows 8 Office 2013
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


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 «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.

Attached Files
File Type: xlsx Excel for Forum.xlsx (10.8 KB, 4 views)
File Type: docx Table for Forum.docx (20.5 KB, 3 views)
Reply With Quote
Old 04-18-2015, 01:19 AM
gmayor's Avatar
gmayor gmayor is online now Windows 7 64bit Office 2010 32bit
Join Date: Aug 2014
Posts: 2,510
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough

It won't begin to work as you have it because the field names do not match what is in the example data file.

If you want to pursue this approach, then see Paul Edstein's tutorial which you can download from

You might find it simpler to use There are however two provisos relating to your data.

1. Don't use the # symbol in field names
2. You can't use a child field as the key field, but as all the records in the table relate to the same name, you don't need the name field in the table. If you put it in the header instead you get:

Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes
Reply With Quote

Thread Tools
Display Modes

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

All times are GMT -7. The time now is 12:46 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft