Hi Simon

See my Outlook examples and also click on the tip link that you see on each example page
http://www.rondebruin.nl/sendmail.htm

You can repeat this line for each file you want to add or create a loop
..Attachments.Add ("C:\test.txt")





--

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


"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