There are a few ways Lori

You can use code like this
http://www.rondebruin.nl/mail/folder2/files.htm


Or if you filter records in a table you can use something like this
http://www.rondebruin.nl/mail/folder3/row2.htm

If you have a different situation paste back


--

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


"LoriH" wrote in message ...
I have 300 reports I create every month, from 3 seperate spreadsheets. I
have created macros with help from this discussion group to automate most of
it. The last step I have is emailing them to my contacts. Is there a way to
use a macro to do this? I can have the email address in the files if needed.