Complex mail merge papaja <papaja.38630e5[ at ]wordbanter.com> 12/10/2008 11:45:51 PM 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. -- papaja

Re: Complex mail merge "macropod" <macropod[ at ]invalid.invalid> 12/11/2008 3:12:01 AM 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] "papaja" <papaja.38630e5[ at ]wordbanter.com> wrote in message news:papaja.38630e5[ at ]wordbanter.com... [Quoted Text] > > 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. > > > > > -- > papaja

Re: Complex mail merge papaja <papaja.386d99f[ at ]wordbanter.com> 12/11/2008 11:11:22 AM 'macropod[_2_ Wrote: > ;383663']Hi papaja, [Quoted Text] > > 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? -- papaja

Re: Complex mail merge "macropod" <macropod[ at ]invalid.invalid> 12/11/2008 10:13:38 PM 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] "papaja" <papaja.386d99f[ at ]wordbanter.com> wrote in message news:papaja.386d99f[ at ]wordbanter.com... [Quoted Text] > > '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? > > > > > -- > papaja

Re: Complex mail merge "macropod" <macropod[ at ]invalid.invalid> 12/12/2008 5:29:59 AM 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" <papaja.386d99f[ at ]wordbanter.com> wrote in message news:papaja.386d99f[ at ]wordbanter.com... [Quoted Text] > > '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? > > > > > -- > papaja

Re: Complex mail merge papaja <papaja.3882b29[ at ]wordbanter.com> 12/12/2008 2:15:56 PM 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 'macropod[_2_ Wrote: > ;383938']PS: There was no need to re-create the folder structure I used > - simply copy the files to a common folder. [Quoted Text] > > -- > Cheers > macropod > [MVP - Microsoft Word] > > > "papaja" papaja.386d99f[ at ]wordbanter.com wrote in message > news:papaja.386d99f[ at ]wordbanter.com...- > > '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? > > > > > -- > papaja- -- papaja

Re: Complex mail merge "macropod" <macropod[ at ]invalid.invalid> 12/12/2008 9:22:32 PM 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] "papaja" <papaja.3882b29[ at ]wordbanter.com> wrote in message news:papaja.3882b29[ at ]wordbanter.com... [Quoted Text] > > 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 > > 'macropod[_2_ Wrote: >> ;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" papaja.386d99f[ at ]wordbanter.com wrote in message >> news:papaja.386d99f[ at ]wordbanter.com...- >> >> '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? >> >> >> >> >> -- >> papaja- > > > > > -- > papaja

Re: Complex mail merge "macropod" <macropod[ at ]invalid.invalid> 12/12/2008 10:00:38 PM 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] "papaja" <papaja.3882b29[ at ]wordbanter.com> wrote in message news:papaja.3882b29[ at ]wordbanter.com... [Quoted Text] > > 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 > > 'macropod[_2_ Wrote: >> ;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" papaja.386d99f[ at ]wordbanter.com wrote in message >> news:papaja.386d99f[ at ]wordbanter.com...- >> >> '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? >> >> >> >> >> -- >> papaja- > > > > > -- > papaja