[Year 12 IT Apps] mail merge....

[Mark Kelly]

Ah, but in Filemaker 'tis but the work of a moment.  (Just to add 
another sub-debate!)

Russell Edwards wrote:
> I partly disagree. Mail merge with Excel is painful, but so is 
> constructing reports with Access!
> 
> Spreadsheets are useful and the kids have to use them, so they may as 
> well learn how to link them to a mail merge.   Personally I use 
> Excel+Word to mark student work and produce 1-page-per-student results 
> summaries. Also in the spreadsheet is the attendance record and 
> calculations based on assessments (e.g. computed VELS levels 
> recommendations to be input into my brain's "on balance judgement" 
> mechanism ;-). Having to do all this in Access or another RDBMS instead 
> of Excel would take twice as long, at least.
> 
> Russell
> 
> On 21/08/2007, at 3:52 PM, Kent Beveridge wrote:
> 
>> I'm with Mark on this one..mail merge with Excel IS painful !
>> KB.
>>
>> Kent Beveridge,
>> I.T. co-ordinator
>> St. Brigids Catholic Sec. College
>> Horsham
>> email.. kbeveridge at stbc.vic.edu.au
>>
>> Wishes and Eggs, one you make and one you break!  A bit like 
>> promises.....
>>
>> “This email and any attachments may be confidential.  You must not 
>> disclose or use the information in this email if you are not the 
>> intended recipient.  If you have received this email in error, please 
>> notify us immediately and delete the email and all copies.  The School 
>> does not guarantee that this email is virus or error free.  The 
>> attached files are provided and my only be used on the basis that the 
>> user assumes all responsibility for any loss, damage or consequence 
>> resulting directly or indirectly from the use of the attached files, 
>> whether caused by the negligence of the sender or not.  The content 
>> and opinions in this email are not necessarily those of the School.”
>>
>> From: itapps-bounces at edulists.com.au on behalf of Mark Kelly
>> Sent: Tue 8/21/2007 1:31 PM
>> To: Year 12 IT Applications Teachers' Mailing List
>> Subject: Re: [Year 12 IT Apps] FW: Ultranet
>>
>> The best advice I have is - DON'T!  Mailmerge from Excel to Word is
>> painful and imperfect.
>>
>> It's far better to use a database's reporting functions. Databases can
>> easily do record-by-record iterative reporting.  Spreadsheets can't.
>>
>> Anyway, having said that, here are some things I used when battling
>> advanced mailmerge a while ago.
>>
>> http://www.mckinnonsc.vic.edu.au/la/it/ipmnotes/howto/merge/index.htm
>>
>> Enjoy.
>>
>> Lappin, Jason M wrote:
>> > Hi list.
>> > Does anyone out there have a tutorial for a mail merge from excel. I 
>> have been doing the "Artificial Realities" task and I would like to 
>> give my kids (and myself) some instructions on how to create the pay 
>> slip using the mail merge in word.
>> > Cheers
>> > Jason Lappin
>> >
>>
> 
> 
> Important - This email and any attachments may be confidential. If 
> received in error, please contact us and delete all copies. Before 
> opening or using attachments check them for viruses and defects. 
> Regardless of any loss, damage or consequence, whether caused by the 
> negligence of the sender or not, resulting directly or indirectly from 
> the use of any attached files our liability is limited to resupplying 
> any affected attachments. Any representations or opinions expressed are 
> those of the individual sender, and not necessarily those of the 
> Department of Education and Early Childhood Development.
> 
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html - 
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology 
> Teachers Association Inc
> 
> 

-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 95789253
kel AT mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au
IT Lecture notes: http://vceit.com
Moderator: IT Applications Mailing List

It's 'i' before 'e' except after 'c'.
Spelling is not an art, it's a sceince.