Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Mailmerge Directory to Document Containing Table

Posted on 2013-06-28
3
Medium Priority
?
293 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 2000 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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

Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
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 …

670 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