Onya File Maker! From memory in Open Office, you can just drag a record out from a database and drop it onto a document. Nothing of course beats just nutting it all out with some raw SQL (* sound of evil laughter *)<br>
<br>
Regards Roland<br><br><br><div><span class="gmail_quote">On 21/08/07, <b class="gmail_sendername">Mark Kelly</b> <<a href="mailto:kel@mckinnonsc.vic.edu.au">kel@mckinnonsc.vic.edu.au</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Ah, but in Filemaker 'tis but the work of a moment. (Just to add<br>another sub-debate!)<br><br>Russell Edwards wrote:<br>> I partly disagree. Mail merge with Excel is painful, but so is<br>> constructing reports with Access!
<br>><br>> Spreadsheets are useful and the kids have to use them, so they may as<br>> well learn how to link them to a mail merge. Personally I use<br>> Excel+Word to mark student work and produce 1-page-per-student results
<br>> summaries. Also in the spreadsheet is the attendance record and<br>> calculations based on assessments (e.g. computed VELS levels<br>> recommendations to be input into my brain's "on balance judgement"
<br>> mechanism ;-). Having to do all this in Access or another RDBMS instead<br>> of Excel would take twice as long, at least.<br>><br>> Russell<br>><br>> On 21/08/2007, at 3:52 PM, Kent Beveridge wrote:
<br>><br>>> I'm with Mark on this one..mail merge with Excel IS painful !<br>>> KB.<br>>><br>>> Kent Beveridge,<br>>> I.T. co-ordinator<br>>> St. Brigids Catholic Sec. College<br>
>> Horsham<br>>> email.. <a href="mailto:kbeveridge@stbc.vic.edu.au">kbeveridge@stbc.vic.edu.au</a><br>>><br>>> Wishes and Eggs, one you make and one you break! A bit like<br>>> promises.....
<br>>><br>>> "This email and any attachments may be confidential. You must not<br>>> disclose or use the information in this email if you are not the<br>>> intended recipient. If you have received this email in error, please
<br>>> notify us immediately and delete the email and all copies. The School<br>>> does not guarantee that this email is virus or error free. The<br>>> attached files are provided and my only be used on the basis that the
<br>>> user assumes all responsibility for any loss, damage or consequence<br>>> resulting directly or indirectly from the use of the attached files,<br>>> whether caused by the negligence of the sender or not. The content
<br>>> and opinions in this email are not necessarily those of the School."<br>>><br>>> From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> on behalf of Mark Kelly<br>
>> Sent: Tue 8/21/2007 1:31 PM<br>>> To: Year 12 IT Applications Teachers' Mailing List<br>>> Subject: Re: [Year 12 IT Apps] FW: Ultranet<br>>><br>>> The best advice I have is - DON'T! Mailmerge from Excel to Word is
<br>>> painful and imperfect.<br>>><br>>> It's far better to use a database's reporting functions. Databases can<br>>> easily do record-by-record iterative reporting. Spreadsheets can't.
<br>>><br>>> Anyway, having said that, here are some things I used when battling<br>>> advanced mailmerge a while ago.<br>>><br>>> <a href="http://www.mckinnonsc.vic.edu.au/la/it/ipmnotes/howto/merge/index.htm">
http://www.mckinnonsc.vic.edu.au/la/it/ipmnotes/howto/merge/index.htm</a><br>>><br>>> Enjoy.<br>>><br>>> Lappin, Jason M wrote:<br>>> > Hi list.<br>>> > Does anyone out there have a tutorial for a mail merge from excel. I
<br>>> have been doing the "Artificial Realities" task and I would like to<br>>> give my kids (and myself) some instructions on how to create the pay<br>>> slip using the mail merge in word.<br>
>> > Cheers<br>>> > Jason Lappin<br>>> ><br>>><br>><br>><br>> Important - This email and any attachments may be confidential. If<br>> received in error, please contact us and delete all copies. Before
<br>> opening or using attachments check them for viruses and defects.<br>> Regardless of any loss, damage or consequence, whether caused by the<br>> negligence of the sender or not, resulting directly or indirectly from
<br>> the use of any attached files our liability is limited to resupplying<br>> any affected attachments. Any representations or opinions expressed are<br>> those of the individual sender, and not necessarily those of the
<br>> Department of Education and Early Childhood Development.<br>><br>> _______________________________________________<br>> <a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe
<br>> IT Applications Mailing List kindly supported by<br>> <a href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</a> -
<br>> Victorian Curriculum and Assessment Authority and<br>> <a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology<br>> Teachers Association Inc<br>><br>><br>
<br>--<br>Mark Kelly<br>Manager - Information Systems<br>McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Direct line / Voicemail: 8520 9085<br>School Phone +613 8520 9000<br>School Fax +613 95789253
<br>kel AT <a href="http://mckinnonsc.vic.edu.au">mckinnonsc.vic.edu.au</a><br><br>Webmaster - <a href="http://www.mckinnonsc.vic.edu.au">http://www.mckinnonsc.vic.edu.au</a><br>IT Lecture notes: <a href="http://vceit.com">
http://vceit.com</a><br>Moderator: IT Applications Mailing List<br><br>It's 'i' before 'e' except after 'c'.<br>Spelling is not an art, it's a sceince.<br><br>_______________________________________________
<br><a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>IT Applications Mailing List kindly supported by<br><a href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html">
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority and<br><a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc
<br></blockquote></div><br><br clear="all"><br>-- <br>Roland Gesthuizen - ICT Coordinator - Westall Secondary College<br><a href="http://www.westallsc.vic.edu.au">http://www.westallsc.vic.edu.au</a><br><br>"Never doubt that a small group of thoughtful, committed citizens can change the world; indeed it is the only thing that ever has." --Margaret Mead