Solved

Formatting a directory in Word 2010

Posted on 2013-01-04
2
311 Views
Last Modified: 2013-01-06
I am trying to format a directory in WORD 2010.  What is the best way to do this.  I would like to print the County each time there is a change in County.

(See attached spreadsheet)

I now have the document set up in columns, I don't know if this is the best way to do this.
I will be using merge fields to populate the document.  The input is on an Excel Spreadsheet.
Directory.docx
0
Comment
Question by:morinia
[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 Comments
 
LVL 32

Expert Comment

by:Paul Sauvé
ID: 38746224
I would use a table rather that columns - you will get better results with Excel.
Directory1.docx
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 38746401
It looks, from your document, as if you are aiming a Labels type of merge, rather than a Directory.

Grouping by one of the fields in the datasource, e.g. 'County'  is more tricky.It can be done using SET, IF and MERGESEQ fields. It would be based on a something that would look like this.

{ IF { MERGESEQ } = "1" "{ MERGEFIELD COUNTY }¶
" "" }{ SET Place1 { MERGEFIELD COUNTY }}¶
{ If { Place2 } <> { Place1 }"¶
{ MERGEFIELD COUNTY }¶

{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD COUNTY }}¶

This is taken from here: http://support.microsoft.com/kb/294686 where there is a fuller explanation.

I have listed this as well as some suggestions for using VBA here:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/Q_23658368.html
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

Do you ever need to create a 20 page Word document for some testing purpose? Are you tired of copying & pasting old boring "lorem ipsum" text over and over again, increasing font size and line space in order to make the document 20+ pages long? Look…
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…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
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…

688 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