WORD/EXCEL 2010: Directory Merge

[dcompto]

Word 2010 Directory mail merge.
Excel 2010 table.

Can anyone help with this? I'll be glad to pay an agreed fee.

I haven't figured out how to configure the merge Form to:
(1) create separate tables for each day of the week, beginning each one on a new page.
(2) only insert the Start field in Column1 when it is the 1st instance of that particular Start time, yet merge the rest of the fields for that record.

[b]Field Names[/b]         [b]Type of Field[/b]
Course_Number       Text
Course_Title        Text
Days                Text
Start               Time (00:00 AM)
End                 Time (00:00 AM)
Room                Text
Campus              Text
Professor           Text

Excel table is sorted by: Start then Course_Number.
Merge Form is formatted as a Table with these field placements:

[b]Start    Course_Number    Course_Title    Professor    Days    Start-End    Room[/b]

NOTE: Column1 should contain only the first instance of a particular Start time. Column6 contains two fields with a dash inbetween.

The first 3 columns of the output should be like:

  [b]Start      Course_Number   Course_Title[/b]
 9:00 AM     ENSC2123.001	Elementary Dynamics
	         MAE 3403.001	Comp Meth in Anls Des
	         MAE 4333.001	Mechanical Metallurgy
	         MAE 5033.001	Adv Biomedical Engr
	         MAE 5473.001	Digital Control Sys
 10:30 AM	ENSC3313.001	Materials Science
	         MAE 3113.001	Meas & Instrumentation
	         MAE 5513.001	Stochastic Systems
	         MAE 5513.801	Stochastic Systems
	         MAE 5563.001	Finite Element Methods
 12:30 PM	MAE 3723.001	Systems I
	         MAE 5693.001	Phase Transformation
	         MAE 5703.001	Optimization Appl

 

[SkipVought]

hi,

Why even use Word?

Use the PivotTable Wizard.

Please post a representative number of FOWS of your source data in Excel.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dcompto]

Hi, Skip,

Why even use Word?

Use the PivotTable Wizard

Answers:

We've always done it that way

I struggle with PivotTables. I never can get the exact format that I need to print.

Here is a copy of the data:

http://dl.dropbox.com/u/5830369/2011sp Class List - Copy.xlsx

 

[dcompto]

Skip,

I'm very close to getting it in PivotTables.
How can I insert a Row Label twice?
Currently, my Row Labels are:

Start
Course_Number
Course_Title
Professor
Days
End
Room

The column1 Start field is filtered, and I need to insert the Start field a second time (unfiltered) between Days and End.

 

[dcompto]

I figured it out.

In the DATA sheet:
Copied Start column, named it Grid_Time, and moved it to ColumnA.
Redefined Table1 range to include new Grid_Time column.

In PivotTable:
Named the sheet "Mon" (for Monday)
Grid_Time column = Sort Oldest to Newest
Days column = Label Filters: Days contains M

Now that Monday's pivot table is done:
Copied Mon sheet; renamed Tue
Days column = Label Filters: Days contains T

Repeat for Wed, Thu, Fri sheets.

 

[SkipVought]

Why so you want a separate sheet for each day?

Why not just use ONE SHEET and change the day in the PAGE/Filter filter field for each print.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dcompto]

Haven't found PAGE filter.

I ultimately have to copy the Pivot Tables to Word where I format 2-columns on 11 x 17 paper with Mon, Tue, and Wed each in a separate column and Thu and Fri together in a column. This provides a single sheet (2-sided) that when folded in half is a single sheet "booklet".

Skip, I really appreciate your help. I've learned a good bit about Pivot Tables today and I'm loving it. Thanks for prodding me into the Pivot Tables arena!