email sheets 2,3,4,5 ect. to users from a list on sheet1

[swieduwi]

I am trying to write a macro (with no success) to email multiple sheets
to multiple users.

When the user clicks Email button a macro should go through the
avalable sheets and email each sheet to the owner. Ie.. The 401-K
sheet should only be sent to (e-mail address removed) and so on

I am using Outlook as the mail client

Thanks for any help
I am really stuck.


+-------------------------------------------------------------------+
|Filename: email-books.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3475 |
+-------------------------------------------------------------------+

 

[Ron de Bruin]

Hi

Look on my site for examples
http://www.rondebruin.nl/sendmail.htm

 

[swieduwi]

Thanks for the Relpy Ron de Bruin

The URL you provided is not workin

 

[Ron de Bruin]

Try it again, it is working

 

[swieduwi]

Sorry, sir, still nothing
is there a way you can post examples here


when I try to ping it get "Unknown host"

 

[Ron de Bruin]

Hi

is there a way you can post examples here

To much there

If you click on this link is it working then
http://www.rondebruin.nl/

 

[swieduwi]

Well I still can't connect, Our firewall must be blocking sites from the
Netherlands

I have also tried by IP and I still can not connect the following are
from tests I ran:

Domain Type Class TTL IP
. A IN 86400 62.45.114.2

62.45.114.2 ASN=15435[Destination Unreachable]
at (agterdenbos.nl.) [Unknown] [Unknown - Firewall
did not respond]

---------------------------------------------------------------------
There was a communication problem.

TCP_ERROR

Problem Description

The system was unable to communicate with the server.

Possible Problem Cause

* The Web server may be down.
* The Web server may be too busy.
* The Web server may be experiencing other problems, preventing it
from responding to clients.
* The communication path may be experiencing problems.

 

[Ron de Bruin]

Strange

Try it at home or on a other system.
you can look here also
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2003_ta/html/odc_xlmail.asp