[Year 12 IPM] U4O1 hints

[Mark Kelly]

Hi All...

Attached is a dummy task showing how mail merge can produce 
sophisticated printed output from an Excel solution (e.g. payslips!)

It's *way* over the top with the formulas, but shows how much complex 
decision-making can be done in Excel and just pulled into Word for 
printed output.

Please especially enjoy the nested VLOOKUP formulas... I think they're 
cool!  :-)

Note the way numbers can be formatted in Word to avoid currency figures 
with 8 decimal places!

Attached:

complexmerge.doc (the form letter)
complexmerge.xls (data file)
MERGE-WordXP-v4.doc (a tute on how to do advanced mail merge in Word XP)

Have fun!

-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria Australia
Phone +613 95780844  Fax +613 95789253
http://www.mckinnonsc.vic.edu.au
IPM Lecture notes: http://vceit.com
Moderator: IPM Mailing List

I'm often spick, but never span.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: complexmerge.doc
Type: application/msword
Size: 21504 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20050719/8abc049f/complexmerge-0001.doc
-------------- next part --------------
A non-text attachment was scrubbed...
Name: complexmerge.xls
Type: application/vnd.ms-excel
Size: 16896 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20050719/8abc049f/complexmerge-0001.xls
-------------- next part --------------
A non-text attachment was scrubbed...
Name: MERGE-WordXP-v5.DOC
Type: application/msword
Size: 77312 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20050719/8abc049f/MERGE-WordXP-v5-0001.dot