Re: Sending E-mail

It doesn't matter much if the *** 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 work*** 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 work***
(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" <rondebruin@xxxxxxxxxxxx> wrote in message
news:uGbleaHjFHA.2852@xxxxxxxxxxxxxxxxxxxxxxx
> Hi
>
> Do you want to send the *** 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 work*** or only in
> the constant list of client's e-mails
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "CB Hamlyn" <cbh@xxxxxxxxxxxxxxxxxxx> wrote in message
> news:11dpshephvgc188@xxxxxxxxxxxxxxxxxxxxx
>> 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 work*** 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 work*** titled "Jones")
>>
>> and
>>
>> Oct 1-7th
>> Order Number - Client - Ship date...
>> 1004 - Smith - 10/03/05
>> (on a work*** titled "Smith")
>>
>> Now, on a separate *** 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 work***.
>>
>> 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 *** 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
>>
>
>


.