Complex mail merge

[papaja]

Hello,
I have sql database with many students. I would like to print some kind
of brochure where every student will get only part of A4 page. It will
look very similar to business cards laid out for printing. This is very
easy to achieve with labels and mail merge.

However I need to have students grouped by university name. Layout
should look like this.

Code:
--------------------

|----------------------------------|
| Law school |
|----------------------------------|
| Student Name | Student Name |
| Average grade | Average grade |
| Course | Course |
|----------------------------------|
| Student Name | Student Name |
| Average grade | Average grade |
| Course | Course |
|----------------------------------|
| Student Name | Student Name |
| Average grade | Average grade |
| Course | Course |
|----------------------------------|
| Student Name | Student Name |
| Average grade | Average grade |
| Course | Course |
|----------------------------------|
| University of Magic |
|----------------------------------|
| Student Name | Student Name |
| Average grade | Average grade |
| Course | Course |
|----------------------------------|
| Student Name | Student Name |
| Average grade | Average grade |
| Course | Course |
|----------------------------------|
| Student Name | Student Name |
| Average grade | Average grade |
| Course | Course |
|----------------------------------|
| Student Name | Student Name |
| Average grade | Average grade |
| Course | Course |
|----------------------------------|
| Student Name | Student Name |
| Average grade | Average grade |
| Course | Course |
|----------------------------------|

--------------------


I hope you get idea. Basically I want universities repeated and then
table for students of that particular University. Can this be achieved
with Mail Merge in Word 2007? Any other option.

 

[macropod]

Hi papaja,

You can do this with a Catalogue/Directory mailmerge. To see how, check out my tutorial at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

 

[papaja]

;383663']Hi papaja,

You can do this with a Catalogue/Directory mailmerge. To see how, check
out my tutorial at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

Example in attachment does not work. I created folders
c:\Users\Waramanga\Documents\System\ and copied Excel file there. When
I open your main word document it also opens Excel and I can see data
in Excel, but there is nothing in Word document. Why?

 

[macropod]

You evidently haven't read/understood the tutorial. It has the field coding for the various example merges. You simply copy & paste
the relevant field code into the mailmerge template and run it.

--
Cheers
macropod
[MVP - Microsoft Word]

;383663']Hi papaja,

You can do this with a Catalogue/Directory mailmerge. To see how, check
out my tutorial at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

Example in attachment does not work. I created folders
c:\Users\Waramanga\Documents\System\ and copied Excel file there. When
I open your main word document it also opens Excel and I can see data
in Excel, but there is nothing in Word document. Why?

 

[macropod]

PS: There was no need to re-create the folder structure I used - simply copy the files to a common folder.

--
Cheers
macropod
[MVP - Microsoft Word]

;383663']Hi papaja,

You can do this with a Catalogue/Directory mailmerge. To see how, check
out my tutorial at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

Example in attachment does not work. I created folders
c:\Users\Waramanga\Documents\System\ and copied Excel file there. When
I open your main word document it also opens Excel and I can see data
in Excel, but there is nothing in Word document. Why?

 

[papaja]

I was eager to see it in action ASAP

You are right I didn't read tutorial, I just wanted to see how ti works
first. Now I read tutorial and everything makes sense.

However, I still have one question. How to format data into 2 columns?
I have a lot of data and I need to save space. Category name would be
title, and then below items should be in 2 columns.

Thanks

;383938']PS: There was no need to re-create the folder structure I used
- simply copy the files to a common folder.

--
Cheers
macropod
[MVP - Microsoft Word]


"papaja" (e-mail address removed) wrote in message

'macropod[_2_ Wrote: -
;383663']Hi papaja,

You can do this with a Catalogue/Directory mailmerge. To see how,
check
out my tutorial at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

--
Cheers
macropod
[MVP - Microsoft Word]

-

Example in attachment does not work. I created folders
c:\Users\Waramanga\Documents\System\ and copied Excel file there.
When
I open your main word document it also opens Excel and I can see data
in Excel, but there is nothing in Word document. Why?

 

[macropod]

Hi papaja,

I don't think you can do that as part of the merge process - you'd have to either pre-process the data into as many columns as you
need, or do some post-processing.

--
Cheers
macropod
[MVP - Microsoft Word]

I was eager to see it in action ASAP

You are right I didn't read tutorial, I just wanted to see how ti works
first. Now I read tutorial and everything makes sense.

However, I still have one question. How to format data into 2 columns?
I have a lot of data and I need to save space. Category name would be
title, and then below items should be in 2 columns.

Thanks

;383938']PS: There was no need to re-create the folder structure I used
- simply copy the files to a common folder.

--
Cheers
macropod
[MVP - Microsoft Word]


"papaja" (e-mail address removed) wrote in message

'macropod[_2_ Wrote: -
;383663']Hi papaja,

You can do this with a Catalogue/Directory mailmerge. To see how,
check
out my tutorial at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

--
Cheers
macropod
[MVP - Microsoft Word]

-

Example in attachment does not work. I created folders
c:\Users\Waramanga\Documents\System\ and copied Excel file there.
When
I open your main word document it also opens Excel and I can see data
in Excel, but there is nothing in Word document. Why?

 

[macropod]

Hi papaja,

On reflection, I think you can get close to what you're after by exposing the field coding and replacing the final <LF> character
with a <TAB>. If you're careful with your paragraph formatting and tab arrangement, you should be able to get what is effectively a
multi-column output (there's no reason to stop at two 'columns' if you don't want to).

--
Cheers
macropod
[MVP - Microsoft Word]

I was eager to see it in action ASAP

You are right I didn't read tutorial, I just wanted to see how ti works
first. Now I read tutorial and everything makes sense.

However, I still have one question. How to format data into 2 columns?
I have a lot of data and I need to save space. Category name would be
title, and then below items should be in 2 columns.

Thanks

;383938']PS: There was no need to re-create the folder structure I used
- simply copy the files to a common folder.

--
Cheers
macropod
[MVP - Microsoft Word]


"papaja" (e-mail address removed) wrote in message

'macropod[_2_ Wrote: -
;383663']Hi papaja,

You can do this with a Catalogue/Directory mailmerge. To see how,
check
out my tutorial at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

--
Cheers
macropod
[MVP - Microsoft Word]

-

Example in attachment does not work. I created folders
c:\Users\Waramanga\Documents\System\ and copied Excel file there.
When
I open your main word document it also opens Excel and I can see data
in Excel, but there is nothing in Word document. Why?