Solved

Mailmerge Directory to Document Containing Table

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I'm writing to share my clumsy experience in using this elegant tool so you can avoid every stupid mistake I made. (I leave it to the authorities to decide if this deserves a place in the Knowledge archives.)  Now that I am on the other side of my l…
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…
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.
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 …

762 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now