Maybe this new example on my site is better for you as a start
http://www.rondebruin.nl/mail/folder3/row2.htm

But maybe you not want a body mail ?





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
Hii Ron,

Thanks your help on create autofilter and split unquie record macro,
but I still have problem on how to:

3) all individual file auto print out with landscape
4) send email with attach file for individual file to user and need
to
cc to my intranet staff and bcc to my team head
5) print out the master file with sub total by approv too

Please give me sugguestion. Thanks!