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

[Russell Edwards]

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.