[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