| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Complex mail merge
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 | |----------------------------------| |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Complex mail merge
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/show...?Number=731107 -- Cheers macropod [MVP - Microsoft Word] "papaja" wrote in message news  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 |
|
#3
|
|||
|
|||
|
Quote:
|
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Complex mail merge
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" wrote in message news '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/show...?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 |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Complex mail merge
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" wrote in message news '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/show...?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 |
|
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Complex mail merge
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" wrote in message news 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" wrote in message news
'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/show...?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 |
|
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Complex mail merge
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" wrote in message news 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" wrote in message news
'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/show...?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 |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex Mail Merge | Mailmerge | |||
| Complex Mail merges | Mailmerge | |||
| A complex question on setting up a mail merge. | Mailmerge | |||
| Complex Mail Merge using Directory Document Source | Mailmerge | |||
| Complex merge | Mailmerge | |||
Linear Mode
