Hi John

Ron de Bruin has a whole series of code examples on how to deal with any
aspect of sending email attachments.
http://www.rondebruin.nl/sendmail.htm

--

Regards
Roger Govier

"JohnEFC" wrote in message
...
Hi,

im trying to automatically email a spreadsheet. i'm hoping to include
this
in a macro.

i'd like to email the sheet i create to an email address which is provided
on the sheet through a Vlookup from a contact list.. (if that makes
sense!?).


is it possible to automatically send this via Microsoft outlook without
starting a whole new message and having to type in the email address and
search for the attachment? - if so is it possible to include this in a
macro?