Solved

Mailmerge Directory to Document Containing Table

Posted on 2013-06-28
3
288 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
  • 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

821 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