sending email winthin a macro via Excell 2000 under win98
 

I have wrote vba code to send email from Excel via Outlook 2000.
Usually I send about 30 emails a day within excell2000, and the
problem I get this warning box which prompts for user input. It say
something like sending email on my behalf. It takes few seconds then I
can click on OK to send it. But it is too much when you have to send
30 email a day. I did see another user having this problem, and I got
lost with the solutions offered.
I understand that it is a security issue within Outlook 2000 and I
know that I have version 9.0.0.6627
I can't use CDO, since I am running Win98 and I need to keep a copy of
the email that is sent.
The Application.DisplayAlerts = False doesn't work.

Please advise, take it easy with me since I have not programmed for
the last 12-years (C and Fourth).

sending email winthin a macro via Excell 2000 under win98
 

Hi

http://www.rondebruin.nl/sendmail.htm#Prevent



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


"Zaidan" wrote in message om...
I have wrote vba code to send email from Excel via Outlook 2000.
Usually I send about 30 emails a day within excell2000, and the
problem I get this warning box which prompts for user input. It say
something like sending email on my behalf. It takes few seconds then I
can click on OK to send it. But it is too much when you have to send
30 email a day. I did see another user having this problem, and I got
lost with the solutions offered.
I understand that it is a security issue within Outlook 2000 and I
know that I have version 9.0.0.6627
I can't use CDO, since I am running Win98 and I need to keep a copy of
the email that is sent.
The Application.DisplayAlerts = False doesn't work.

Please advise, take it easy with me since I have not programmed for
the last 12-years (C and Fourth).

sending email winthin a macro via Excell 2000 under win98
 

You can try this also instead of .Send

.Display
'You can try to use the line below (not always reliable)
'It will press the Send button in every mail for you
'Application.SendKeys "%S"




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


"Ron de Bruin" wrote in message ...
Hi

http://www.rondebruin.nl/sendmail.htm#Prevent



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


"Zaidan" wrote in message om...
I have wrote vba code to send email from Excel via Outlook 2000.
Usually I send about 30 emails a day within excell2000, and the
problem I get this warning box which prompts for user input. It say
something like sending email on my behalf. It takes few seconds then I
can click on OK to send it. But it is too much when you have to send
30 email a day. I did see another user having this problem, and I got
lost with the solutions offered.
I understand that it is a security issue within Outlook 2000 and I
know that I have version 9.0.0.6627
I can't use CDO, since I am running Win98 and I need to keep a copy of
the email that is sent.
The Application.DisplayAlerts = False doesn't work.

Please advise, take it easy with me since I have not programmed for
the last 12-years (C and Fourth).

sending email winthin a macro via Excell 2000 under win98
 

Dear Ron,
You amaze me in your quick responses. I do have a question and a
suggestion.
I think using Application.SendKeys "%S" will become very reliable if you
put a one second PAUSE (time loop) after executing .Display and one
second Pause after executing Application.SendKeys "%S". I have not tried
it, but I wanted to see what you think.
Then if I use this Application.SendKeys "%S", then I need to disable the
Spell Check feature. even though there are no misspelled words, but it
does stop at strange names or long numbers. How do you disable the spell
check via VBA, and then re-enable it what you are done.

As for the option of http://www.rondebruin.nl/sendmail.htm#Prevent
Do I need to do any coding for the Redemption add-In

thank you





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

sending email winthin a macro via Excell 2000 under win98
 

Hi

will become very reliable

The problem is that if it is working for you it will maybe not work correct on a other machine.
If it is for personal use then use it, but not if others also working with it.

Spell Check feature
Don't know how to do this in Outlook

Do I need to do any coding for the Redemption add-In
Yes you do



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


"K Zaidan" wrote in message ...

Dear Ron,
You amaze me in your quick responses. I do have a question and a
suggestion.
I think using Application.SendKeys "%S" will become very reliable if you
put a one second PAUSE (time loop) after executing .Display and one
second Pause after executing Application.SendKeys "%S". I have not tried
it, but I wanted to see what you think.
Then if I use this Application.SendKeys "%S", then I need to disable the
Spell Check feature. even though there are no misspelled words, but it
does stop at strange names or long numbers. How do you disable the spell
check via VBA, and then re-enable it what you are done.

As for the option of http://www.rondebruin.nl/sendmail.htm#Prevent
Do I need to do any coding for the Redemption add-In

thank you





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!