Solved

Formatting a directory in Word 2010

Posted on 2013-01-04
2
304 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
2 Comments
 
LVL 31

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Text wrapping issue with Word 14 40
Error during copy and paste 3 86
Transferring select excel data to a Word Document 5 54
Header of docx file 17 98
There is a feature provided by MS Word that lets you create an Table of Contents for your Word document automatically. To use this feature for other documents there are two steps involved,   1.  Prepare your document for a table of contents (he…
The Selection object is designed for user interaction. It has a Range property, so it can be used in most places that a Range object can. Recorded macros must use the Selection because they are simply copying what the user is doing. A Range prope…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
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 …

863 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

25 Experts available now in Live!

Get 1:1 Help Now