Mail a Sheet contents using excel..

[Majid LAISSI]

Hi,

I would like to make a macro that sends the contents of a sheet to a
specific recipient.

I found in the internet that it's possible using :

Dim myvariable As Outlook.Application

The problem is that this type is not recognized by Excel, and when i go to
the menu "Tools/Preferences/" I can't find the Outlook Library..

Can someone please tell me where to locate this library?

Thanks in advance.

 

[Don Guillett]

Have a look here for ways to email
http://www.rondebruin.nl/

 

[Paul B]

Majid, have a look here for some tips
http://www.rondebruin.nl/sendmail.htm#Workbook.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Majid LAISSI]

Thanks this works but Outlook Express asks for an authorisation from the
user before sending the mail
Is there any way to avoid this ?

 

[Ron de Bruin]

Read this
http://www.rondebruin.nl/mail/prevent.htm

 

[Majid LAISSI]

Thank's everybody for your valuable answers..

Majid