If you are using outlook, just loop through all files adding each as a
separate file, just as the zip is added, and also set the .cc and ,bcc
properties as you to with the .To property.

HTH

Bob

"Simon" wrote in message
...
Using XL'03, using Ron's tips, I have successfully sent one workbook,
or sheet or range but I would like to send more than one workbook.

I have used VBA to put the files in a folder and zip and send them,
but I do not wish to zip them.

How can I d this and how can I also use the e.g. .To and .CC .BCC as
well.


Many thanks.

Simon