Solved

Mailmerge Directory to Document Containing Table

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
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 envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

635 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