[Year 12 IT Apps] mail merge....
Roland Gesthuizen
rgesthuizen at gmail.com
Wed Aug 22 18:16:16 EST 2007
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> 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
> >>
> >> 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.
>
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070822/3aa67bf0/attachment.html
More information about the itapps
mailing list