Re: Sending E-mail

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <cbh@xxxxxxxxxxxxxxxxxxx> wrote in message news:11dq8o68j8blje2@xxxxxxxxxxxxxxxxxxxxx
> 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
>>>
>>
>>
>
>


.

Quantcast