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

Mark Kelly kel at mckinnonsc.vic.edu.au
Wed Aug 22 18:33:27 EST 2007


Ah, raw squirrel.  The memories of a starving student's trip to Hyde 
Park, London with no money...

Roland Gesthuizen wrote:
> 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 *)
> 
> Regards Roland
> 
> 
> On 21/08/07, *Mark Kelly* <kel at mckinnonsc.vic.edu.au 
> <mailto:kel at mckinnonsc.vic.edu.au>> wrote:
> 
>     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
>     <mailto: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
>     <mailto: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 <http://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.
> 
>     _______________________________________________
>     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
> 
> 
> 
> 
> -- 
> Roland Gesthuizen - ICT Coordinator - Westall Secondary College
> http://www.westallsc.vic.edu.au
> 
> "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 _______________________________________________
> http://www.edulists.com.au <http://www.edulists.com.au> - FAQ, 
> resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.auvce/studies/infotech/infotechindex.html 
> <http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html > 
> - Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au <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.



More information about the itapps mailing list