Hi,

Is it possible to create a macro that will automatically attach th
workbook it is running from into a blank email using the computer'
default message program? If so, how would I do this? Thanks i
advance.

Rama

--
Raman32
-----------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...fo&userid=2474
View this thread: http://www.excelforum.com/showthread.php?threadid=39503

Hi there,

Not sure about the default mail program, but here are a couple of examples
with known programs ...

Outlook:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=97

Non-Outlook MAPI:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=311

HTH

--
Regards,
Zack Barresse, aka firefytr


"Raman325" wrote in
message ...

Hi,

Is it possible to create a macro that will automatically attach the
workbook it is running from into a blank email using the computer's
default message program? If so, how would I do this? Thanks in
advance.

Raman


--
Raman325
------------------------------------------------------------------------
Raman325's Profile:
http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=395039

Hi

If you use the SendMail examples it will work in Outlook and Outlook Express
http://www.rondebruin.nl/sendmail.htm

Another option is CDO that don't use a mail program
http://www.rondebruin.nl/cdo.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Raman325" wrote in message
...

Hi,

Is it possible to create a macro that will automatically attach the
workbook it is running from into a blank email using the computer's
default message program? If so, how would I do this? Thanks in
advance.

Raman


--
Raman325
------------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=395039