Emailing using VB
 

Hi
Can anyone out there give me a code to automatically send
an excel book via email
i.e. I have done some work on a project and saved, now
press a button to auto send as email back to boss

Office 2001 or 2003

Many thanks

Emailing using VB
 

Hi
see: http://www.rondebruin.nl/sendmail.htm

--
Regards
Frank Kabel
Frankfurt, Germany


JohnUk wrote:
Hi
Can anyone out there give me a code to automatically send
an excel book via email
i.e. I have done some work on a project and saved, now
press a button to auto send as email back to boss

Office 2001 or 2003

Many thanks

Emailing using VB
 

look in Excel VBA help at the sendmail method.

--
Regards,
Tom Ogilvy


"JohnUk" wrote in message
...
Hi
Can anyone out there give me a code to automatically send
an excel book via email
i.e. I have done some work on a project and saved, now
press a button to auto send as email back to boss

Office 2001 or 2003

Many thanks

Emailing using VB
 

Frank
Thank you - much appreciated
John