[Year 12 IPM] - Macro to Print a worksheet in Excel

[Sheard, Brian B]

Hi Lucy,
 
A better idea is to use Mail Merge. Set up a word document which has all the bits you need on it then merge from your Excel work sheet. You could need to set up a Report from inside Excel, because the Mail Marge function needs the first row to contain the field names it is using for the merge.
 
Hope this helps,
 
Brian

________________________________

From: ipm-bounces at edulists.com.au on behalf of lgusak at ansonic.com.au
Sent: Mon 18-July-2005 1:20 PM
To: ipm at edulists.com.au
Subject: [Year 12 IPM] - Macro to Print a worksheet in Excel



Hi,

I was just wondering if anyone has a handout/tutorial on how to create a
macro in Excel to print a specified range (ie. a payslip) of a worksheet.

Thank you in anticipation

Lucy Gusak
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IPM Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc




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 & Training.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 4400 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20050719/14dfede5/attachment.bin