Philconospam@aol.com

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Philco - 18 Mar 2004 01:11 GMT

I am with a company that does major construction projects in 200+ counties in 22 states. We have local engineering firms representing our interests with city and county engineers. Many represent us in multiple counties. I have these documented in an Excel97 spreadsheet
What I would like to be able to do is create a report, where I group counties by engineers in a
Word 97 document so it looks something like the example below
Engineer
County
County
CountyC [All this data is in the spreadsheet
Engineer
County
County

and so on........
I have been trying to set this up by mailmerge: using both letter and catalog with no success. Any suggestions on how to set this up to work in an automated way would be most appreciated

Philc

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 18 Mar 2004 03:28 GMT

You will need a Catalog type mailmerge main document with the following
field constructions in it

{ IF {MERGESEQ} = "1" "{MERGEFIELD "Engineer"}
" ""} {SET Place1 {MERGEFIELD "Engineer"}}
{IF {Place2}<>{Place1}"
{MERGEFIELD "Engineer"}

{MERGEFIELD "Country"} " "{MERGEFIELD "Country"} " }
{SET Place2{MERGEFIELD "Engineer" }}

Each pair of field delimiters must be inserted using Ctrl+F9

Take a look at the Knowledge Base article "HOW TO: Use Mail Merge to Create
a List Sorted by Category in Word 2002" at

http://support.microsoft.com/?kbid=294686

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>I am with a company that does major construction projects in 200+ counties
>in 22 states. We have local engineering firms representing our interests
[quoted text clipped - 17 lines]
>
> Philco

Reply to this Message