Re: Sending e-mail - Ron, you still there?
From: Ron de Bruin (rondebruin_at_kabelfoon.nl)
Date: 09/21/04
- Next message: Grant: "Preserve formatting setting in VBA crashing Excel"
- Previous message: JT: "VB error message"
- In reply to: Steph: "Sending e-mail - Ron, you still there?"
- Next in thread: Steph: "Re: Sending e-mail - Ron, you still there?"
- Reply: Steph: "Re: Sending e-mail - Ron, you still there?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 21 Sep 2004 22:58:22 +0200
Hi Steph
Can't you open the 10 files in a loop (macro) and check your condition for sending a mail (yes or no)
if your condition is 10 * yes we can send the last mail also then.
Is this a option for you?
-- Regards Ron de Bruin http://www.rondebruin.nl "Steph" <verysmallrox@yahoo.com> wrote in message news:%23rNwWtBoEHA.592@TK2MSFTNGP11.phx.gbl... > Could you please help me with one more thing? I have 10 files within a > folder. Within each file is a click_event that calls you CDO send email > code. When the click event is executed on each file, I would like a single > e-mail sent to one individual. That part is pretty easy. > > Now the tough part - I would also like another e-mail sent to a different > individual when ALL of the files within the folder have executed the click > event. Any ideas? I've been beating my head against a wall trying to > figure this out....and needless to say, my head is getting quite sore! > > Cheers. > >
- Next message: Grant: "Preserve formatting setting in VBA crashing Excel"
- Previous message: JT: "VB error message"
- In reply to: Steph: "Sending e-mail - Ron, you still there?"
- Next in thread: Steph: "Re: Sending e-mail - Ron, you still there?"
- Reply: Steph: "Re: Sending e-mail - Ron, you still there?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|