Merge with section headings...

[Cloy]

I'm running Office 2004 on OS X 10.4.10.

I'm trying to use Word to generate a calendar of events (using the
"catalog" format) from an Excel spreadsheet so I get the following
format:

SUNDAY
-one event there
-another event
-yet another event

MONDAY
-one event here


A couple notes...
-The day of the week is a field in each record (so I can filter on
that field).
-The Excel spreadsheet is frequently generated from a larger
database, so modifying it before pulling records isn't really an
option.
-All days of the week appear on every schedule. (Every schedule as a
Sunday, a Monday, etc.)

Thanks, in advance!

-Cloy

 

[John McGhie]

Hi Cloy:

OK, that's great, you have told us exactly what you want to do (which is
great!!) and exactly the versions of the software you want to do it with (we
love you already!!)

What you haven't yet told us, is what you are having difficulty with?

My first suggestion is that you will need to do a little more processing on
your data before you get it into Word. Which means you are going to HAVE to
modify the Excel data.

Of course you can't touch the main spreadsheet: but you CAN create an
intermediate LINKED spreadsheet that sucks the required data from the main
sheet and allows you to sort and re-order the data before you merge it into
Word.

Word is limited in its selection and decision-making capacity. It expects
that the data will be in the correct sequence before it sees it, and that
you want to use it all.

So use Excel to ensure you present Word only with data in the correct
layout, and only the data you want to use. You will have a much easier
development task.

Cheers

I'm running Office 2004 on OS X 10.4.10.

I'm trying to use Word to generate a calendar of events (using the
"catalog" format) from an Excel spreadsheet so I get the following
format:

SUNDAY
-one event there
-another event
-yet another event

MONDAY
-one event here


A couple notes...
-The day of the week is a field in each record (so I can filter on
that field).
-The Excel spreadsheet is frequently generated from a larger
database, so modifying it before pulling records isn't really an
option.
-All days of the week appear on every schedule. (Every schedule as a
Sunday, a Monday, etc.)

Thanks, in advance!

-Cloy

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, NT, Australia. S12.22.1918,E136.99.5392
+61 4 1209 1410, mailto:[email protected]

 

[Cloy]

What you haven't yet told us, is what you are having difficulty with?

....snip...

Thanks for the response, John.

I can generate the following:

Sunday - one event
Sunday - another event...

but I cannot get the days plugged in as section headings (i.e., events
for each day of the week grouped together in a distinct section), as
in my example.

Thanks! -CT

 

[macropod]

Hi Cloy,

Assuming you've got a paragraph somewhere that has the day name at the start, you could try using STYLEREF fields in the header
combined with a series of IF tests. For example:
{IF{STYLEREF MyStyle}= "Su*" Sunday {IF{STYLEREF MyStyle}= "Mo*" Monday {IF{STYLEREF MyStyle}= "Tu*" Tuesday {IF{STYLEREF MyStyle}=
"We*"Wednesday {IF{STYLEREF MyStyle}= "Th*" Thursday {IF{STYLEREF MyStyle}= "Fr*" Friday Saturday }}}}}}
where 'MyStyle' is the name of the paragraph style for the paragraph holding the day name.

With the above coding, it doesn't matter what follows the weekday name in the same paragraph - only the day name is displayed in the
header.

Cheers