Solved

Mailmerge Directory to Document Containing Table

Posted on 2013-06-28
3
289 Views
Last Modified: 2013-07-19
I am trying to populate a directory using mail merge where the data layout on the page is formatted using a table.  Every time a record is merged, Word is appending a carriage return between each row in the table, creating what I assume to be a page of individual tables each with a blank line between them - is there any way to stop it doing this?  The received wisdom seems to be to use VB to parse the document after creation but I'm not particularly keen to do this.
0
Comment
Question by:frasierphilips
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 39283884
The carriage return (paragraph mark) is being copied from the main document.

A directory merge will repeat the fixed text and layout from the main document for each record, except for the final (mandatory) paragraph mark, so mark sure that there isn't another one - use the Show/Hide button (¶) to see.
0
 

Author Comment

by:frasierphilips
ID: 39283890
I forgot to mention - I have inserted conditional field codes at the head of the page, to add a page break when a particular field subject changes - it's the carriage return after this code fragment that seems to being replicated however if I remove it, the code drops into the first table cell and is then no longer executed so it seems to be mandatory, however if it is removed the blank line does then vanish.
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 39284387
Try this. It's an extra step, but doesn't use VBA.

Convert the table in the main document to tab-separated text.

Run the merge, select the text in the result document and convert it to a table.
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is often necessary in this forum and others to illustrate Word fields as text with the field delimiters replaced with the curly brackets that the delimiters resemble when field codes are being displayed on the document. This means that the text c…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
Suggested Courses

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question