Hi CB

You can insert a Vlookup formula that lookup the E-mail address also in the sheets that you create with a macro
Then you can use this macro tio send them
http://www.rondebruin.nl/mail/folder3/mail5.htm


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


"CB Hamlyn" wrote in message ...
It doesn't matter much if the sheet is attached or if it composes the body. If I could choose either probably make it the body as
the recipients are not all that computer literate.

There's basically a historical record worksheet that lists the possible clients and whether they prefer printed/faxed copies or
e-mail (and addresses where appropriate). This is the only place where the client's e-mail addresses are stored.

There is of course a front end user utility that allows the user of the macro to view/edit the historical list.

What I plan to do is go through this historical list in a macro and for every name I find in the historical list that has it's own
worksheet (schedule), I will either print it or e-mail it automatically based on that clients preference.

I'll look further into your outlook examples in the mean time. I should be able to figure out a way to do this, but I appreciate
any information you can give me that may be more appropriate to what I'm doing (if it's not already laid out on your website that
is).

Thank you very much for your time :)
CB Hamlyn


"Ron de Bruin" wrote in message ...
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