Hi

Do you want to send the sheet in the Body ?

You can't program the envelope in Excel 2000
And you must use my Outlook body Examples.

Do you have the client Mail address also on the worksheet or only in
the constant list of client's e-mails

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


"CB Hamlyn" wrote in message ...
WinXP Pro SP2, Excel 2000, OE6

I have a client shipping schedule which includes all of our clients' shipping dates for a three month period. I have a program
which gathers a list of the clients in the most recent schedule, then filters on each client, copy's the filtered schedule into a
worksheet named after the client. For example...

Oct 1-7th
Order Number - Client - Ship date...
1001 - Jones - 10/01/05
1004 - Smith - 10/03/05...

Becomes:
Oct 1-7th
Order Number - Client - Ship date...
1001 - Jones - 10/01/05
(on a worksheet titled "Jones")

and

Oct 1-7th
Order Number - Client - Ship date...
1004 - Smith - 10/03/05
(on a worksheet titled "Smith")

Now, on a separate sheet I have a constant list of client's e-mail addresses. I basically want to browse this list and if I find
a client with an e-mail address who has a report, I want to e-mail said worksheet.

The built-in toolbar for E-Mail in Excel works exactly perfectly for my needs. However trying to capture a macro to use the
toolbar has been most unsuccessful. Is there a way to exactly emulate the pressing of the envelope toolbar button, fill in the
"To:" and "Subject:" lines and send it off?

I did find http://www.rondebruin.nl/sendmail.htm in my searching but it seems like a long way to go when all I seem to need to do
is push that E-mail button, and send the sheet off.

Can anyone tell me if there's a simple way to do what I'm trying to do or if I need to work with the sendmail thing?

Thank you for your time.
CB Hamlyn