i have to press sent to email

[Excel Ox]

I am using outlook express and have to press send for the email to go.The msg
is correct. can anyone tell how to get around this.
thanks
--
I B Aver

[Paul B]

See if this will work,

http://www.rondebruin.nl/mail/prevent.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message
news:67B27EB4-75B0-4582-8D47-97E76711F689@microsoft.com...
> I am using outlook express and have to press send for the email to go.The
msg
> is correct. can anyone tell how to get around this.
> thanks
> --
> I B Aver

[Excel Ox]

I have already tried this and I still get a window with the message and have
to press send.
I really appreciate your response
--
I B Aver


"Paul B" wrote:

> See if this will work,
>
> http://www.rondebruin.nl/mail/prevent.htm
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message
> news:67B27EB4-75B0-4582-8D47-97E76711F689@microsoft.com...
> > I am using outlook express and have to press send for the email to go.The
> msg
> > is correct. can anyone tell how to get around this.
> > thanks
> > --
> > I B Aver
>
>
>

[Ron de Bruin]

Which mail program do you use

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


"Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:C43F7FD3-4D5F-45D3-9ED4-E5AA895C7546@microsoft.com...
>I have already tried this and I still get a window with the message and have
> to press send.
> I really appreciate your response
> --
> I B Aver
>
>
> "Paul B" wrote:
>
>> See if this will work,
>>
>> http://www.rondebruin.nl/mail/prevent.htm
>>
>> --
>> Paul B
>> Always backup your data before trying something new
>> Please post any response to the newsgroups so others can benefit from it
>> Feedback on answers is always appreciated!
>> Using Excel 2002 & 2003
>>
>> "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message
>> news:67B27EB4-75B0-4582-8D47-97E76711F689@microsoft.com...
>> > I am using outlook express and have to press send for the email to go.The
>> msg
>> > is correct. can anyone tell how to get around this.
>> > thanks
>> > --
>> > I B Aver
>>
>>
>>

[Excel Ox]

I am using outlook express and excel 2003
--
I B Aver


"Ron de Bruin" wrote:

> Which mail program do you use
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:C43F7FD3-4D5F-45D3-9ED4-E5AA895C7546@microsoft.com...
> >I have already tried this and I still get a window with the message and have
> > to press send.
> > I really appreciate your response
> > --
> > I B Aver
> >
> >
> > "Paul B" wrote:
> >
> >> See if this will work,
> >>
> >> http://www.rondebruin.nl/mail/prevent.htm
> >>
> >> --
> >> Paul B
> >> Always backup your data before trying something new
> >> Please post any response to the newsgroups so others can benefit from it
> >> Feedback on answers is always appreciated!
> >> Using Excel 2002 & 2003
> >>
> >> "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message
> >> news:67B27EB4-75B0-4582-8D47-97E76711F689@microsoft.com...
> >> > I am using outlook express and have to press send for the email to go.The
> >> msg
> >> > is correct. can anyone tell how to get around this.
> >> > thanks
> >> > --
> >> > I B Aver
> >>
> >>
> >>
>
>
>

[weavtennis]

The following works just fine in my '97 version of Excel and V6 OE.


Sub Sendemails()
addy = "myaddress@myISP.com"
ActiveWorkbook.Sendmail Recipients:=addy
End Sub

There may be more parameters (like email subject and text in the message) - but I get an email in my OE outbox without pressing more keys.

If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail dialog.

[Ron de Bruin]

Hi Excel Ox

You can turn off the security warning then

See
http://www.rondebruin.nl/mail/prevent.htm


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


"Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:B7BAFE3D-6620-4469-901A-FF5ADE14D167@microsoft.com...
>I am using outlook express and excel 2003
> --
> I B Aver
>
>
> "Ron de Bruin" wrote:
>
>> Which mail program do you use
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:C43F7FD3-4D5F-45D3-9ED4-E5AA895C7546@microsoft.com...
>> >I have already tried this and I still get a window with the message and have
>> > to press send.
>> > I really appreciate your response
>> > --
>> > I B Aver
>> >
>> >
>> > "Paul B" wrote:
>> >
>> >> See if this will work,
>> >>
>> >> http://www.rondebruin.nl/mail/prevent.htm
>> >>
>> >> --
>> >> Paul B
>> >> Always backup your data before trying something new
>> >> Please post any response to the newsgroups so others can benefit from it
>> >> Feedback on answers is always appreciated!
>> >> Using Excel 2002 & 2003
>> >>
>> >> "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message
>> >> news:67B27EB4-75B0-4582-8D47-97E76711F689@microsoft.com...
>> >> > I am using outlook express and have to press send for the email to go.The
>> >> msg
>> >> > is correct. can anyone tell how to get around this.
>> >> > thanks
>> >> > --
>> >> > I B Aver
>> >>
>> >>
>> >>
>>
>>
>>

[Excel Ox]

Thanks weavtennis. I still get the email page and have to press send.
--
I B Aver


"weavtennis" wrote:

>
> The following works just fine in my '97 version of Excel and V6 OE.
>
>
> Sub Sendemails()
> addy = "myaddress@myISP.com"
> ActiveWorkbook.Sendmail Recipients:=addy
> End Sub
>
> There may be more parameters (like email subject and text in the
> message) - but I get an email in my OE outbox without pressing more
> keys.
>
> If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail
> dialog.
>
>
> --
> weavtennis
> ------------------------------------------------------------------------
> weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
> View this thread: http://www.excelforum.com/showthread...hreadid=514057
>
>

[Ron de Bruin]

Do you mean that it stay in the outbox ?

See Tools>Options>Send in Outlook Express

Check : "Send messages immediately"

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


"Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:A0215BA3-4A6C-4CB4-9A54-65E2D5CC9DE3@microsoft.com...
> Thanks weavtennis. I still get the email page and have to press send.
> --
> I B Aver
>
>
> "weavtennis" wrote:
>
>>
>> The following works just fine in my '97 version of Excel and V6 OE.
>>
>>
>> Sub Sendemails()
>> addy = "myaddress@myISP.com"
>> ActiveWorkbook.Sendmail Recipients:=addy
>> End Sub
>>
>> There may be more parameters (like email subject and text in the
>> message) - but I get an email in my OE outbox without pressing more
>> keys.
>>
>> If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail
>> dialog.
>>
>>
>> --
>> weavtennis
>> ------------------------------------------------------------------------
>> weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
>> View this thread: http://www.excelforum.com/showthread...hreadid=514057
>>
>>

[Excel Ox]

the macro executes to the .send instruction. When it is executed, i get a
outlook express send-mail window that I have to press send for the message to
be sent.
--
I B Aver


"Ron de Bruin" wrote:

> Do you mean that it stay in the outbox ?
>
> See Tools>Options>Send in Outlook Express
>
> Check : "Send messages immediately"
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:A0215BA3-4A6C-4CB4-9A54-65E2D5CC9DE3@microsoft.com...
> > Thanks weavtennis. I still get the email page and have to press send.
> > --
> > I B Aver
> >
> >
> > "weavtennis" wrote:
> >
> >>
> >> The following works just fine in my '97 version of Excel and V6 OE.
> >>
> >>
> >> Sub Sendemails()
> >> addy = "myaddress@myISP.com"
> >> ActiveWorkbook.Sendmail Recipients:=addy
> >> End Sub
> >>
> >> There may be more parameters (like email subject and text in the
> >> message) - but I get an email in my OE outbox without pressing more
> >> keys.
> >>
> >> If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail
> >> dialog.
> >>
> >>
> >> --
> >> weavtennis
> >> ------------------------------------------------------------------------
> >> weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
> >> View this thread: http://www.excelforum.com/showthread...hreadid=514057
> >>
> >>
>
>
>

[Excel Ox]

The send immediately has been checked all along.
--
I B Aver


"Excel Ox" wrote:

> the macro executes to the .send instruction. When it is executed, i get a
> outlook express send-mail window that I have to press send for the message to
> be sent.
> --
> I B Aver
>
>
> "Ron de Bruin" wrote:
>
> > Do you mean that it stay in the outbox ?
> >
> > See Tools>Options>Send in Outlook Express
> >
> > Check : "Send messages immediately"
> >
> > --
> > Regards Ron de Bruin
> > http://www.rondebruin.nl
> >
> >
> > "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:A0215BA3-4A6C-4CB4-9A54-65E2D5CC9DE3@microsoft.com...
> > > Thanks weavtennis. I still get the email page and have to press send.
> > > --
> > > I B Aver
> > >
> > >
> > > "weavtennis" wrote:
> > >
> > >>
> > >> The following works just fine in my '97 version of Excel and V6 OE.
> > >>
> > >>
> > >> Sub Sendemails()
> > >> addy = "myaddress@myISP.com"
> > >> ActiveWorkbook.Sendmail Recipients:=addy
> > >> End Sub
> > >>
> > >> There may be more parameters (like email subject and text in the
> > >> message) - but I get an email in my OE outbox without pressing more
> > >> keys.
> > >>
> > >> If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail
> > >> dialog.
> > >>
> > >>
> > >> --
> > >> weavtennis
> > >> ------------------------------------------------------------------------
> > >> weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
> > >> View this thread: http://www.excelforum.com/showthread...hreadid=514057
> > >>
> > >>
> >
> >
> >

[Ron de Bruin]

Strange

You can try to register OE again

Go to Start | Run and type the following:
"C:\PROGRAM FILES\OUTLOOK EXPRESS\MSIMN.EXE" /reg
(Check the path to msimn.exe to make sure that is correct)


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


"Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:F27BC477-CD22-43F5-A765-9C85AE9AC72B@microsoft.com...
> The send immediately has been checked all along.
> --
> I B Aver
>
>
> "Excel Ox" wrote:
>
>> the macro executes to the .send instruction. When it is executed, i get a
>> outlook express send-mail window that I have to press send for the message to
>> be sent.
>> --
>> I B Aver
>>
>>
>> "Ron de Bruin" wrote:
>>
>> > Do you mean that it stay in the outbox ?
>> >
>> > See Tools>Options>Send in Outlook Express
>> >
>> > Check : "Send messages immediately"
>> >
>> > --
>> > Regards Ron de Bruin
>> > http://www.rondebruin.nl
>> >
>> >
>> > "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:A0215BA3-4A6C-4CB4-9A54-65E2D5CC9DE3@microsoft.com...
>> > > Thanks weavtennis. I still get the email page and have to press send.
>> > > --
>> > > I B Aver
>> > >
>> > >
>> > > "weavtennis" wrote:
>> > >
>> > >>
>> > >> The following works just fine in my '97 version of Excel and V6 OE.
>> > >>
>> > >>
>> > >> Sub Sendemails()
>> > >> addy = "myaddress@myISP.com"
>> > >> ActiveWorkbook.Sendmail Recipients:=addy
>> > >> End Sub
>> > >>
>> > >> There may be more parameters (like email subject and text in the
>> > >> message) - but I get an email in my OE outbox without pressing more
>> > >> keys.
>> > >>
>> > >> If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail
>> > >> dialog.
>> > >>
>> > >>
>> > >> --
>> > >> weavtennis
>> > >> ------------------------------------------------------------------------
>> > >> weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
>> > >> View this thread: http://www.excelforum.com/showthread...hreadid=514057
>> > >>
>> > >>
>> >
>> >
>> >

[Excel Ox]

I cut and pasted the info in the "run" box and "Program not found" msg. I
"Browsed" and found it then added /reg, and "Program not found again". when i
remove the /reg, the progam runs.i am sys managed.
--
I B Aver


"Ron de Bruin" wrote:

> Strange
>
> You can try to register OE again
>
> Go to Start | Run and type the following:
> "C:\PROGRAM FILES\OUTLOOK EXPRESS\MSIMN.EXE" /reg
> (Check the path to msimn.exe to make sure that is correct)
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:F27BC477-CD22-43F5-A765-9C85AE9AC72B@microsoft.com...
> > The send immediately has been checked all along.
> > --
> > I B Aver
> >
> >
> > "Excel Ox" wrote:
> >
> >> the macro executes to the .send instruction. When it is executed, i get a
> >> outlook express send-mail window that I have to press send for the message to
> >> be sent.
> >> --
> >> I B Aver
> >>
> >>
> >> "Ron de Bruin" wrote:
> >>
> >> > Do you mean that it stay in the outbox ?
> >> >
> >> > See Tools>Options>Send in Outlook Express
> >> >
> >> > Check : "Send messages immediately"
> >> >
> >> > --
> >> > Regards Ron de Bruin
> >> > http://www.rondebruin.nl
> >> >
> >> >
> >> > "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:A0215BA3-4A6C-4CB4-9A54-65E2D5CC9DE3@microsoft.com...
> >> > > Thanks weavtennis. I still get the email page and have to press send.
> >> > > --
> >> > > I B Aver
> >> > >
> >> > >
> >> > > "weavtennis" wrote:
> >> > >
> >> > >>
> >> > >> The following works just fine in my '97 version of Excel and V6 OE.
> >> > >>
> >> > >>
> >> > >> Sub Sendemails()
> >> > >> addy = "myaddress@myISP.com"
> >> > >> ActiveWorkbook.Sendmail Recipients:=addy
> >> > >> End Sub
> >> > >>
> >> > >> There may be more parameters (like email subject and text in the
> >> > >> message) - but I get an email in my OE outbox without pressing more
> >> > >> keys.
> >> > >>
> >> > >> If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail
> >> > >> dialog.
> >> > >>
> >> > >>
> >> > >> --
> >> > >> weavtennis
> >> > >> ------------------------------------------------------------------------
> >> > >> weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
> >> > >> View this thread: http://www.excelforum.com/showthread...hreadid=514057
> >> > >>
> >> > >>
> >> >
> >> >
> >> >
>
>
>

[Excel Ox]

i finally got it to run by adding a space before the /. the mail page comes
up smaller now but i still have to press send.
--
I B Aver


"Excel Ox" wrote:

> I cut and pasted the info in the "run" box and "Program not found" msg. I
> "Browsed" and found it then added /reg, and "Program not found again". when i
> remove the /reg, the progam runs.i am sys managed.
> --
> I B Aver
>
>
> "Ron de Bruin" wrote:
>
> > Strange
> >
> > You can try to register OE again
> >
> > Go to Start | Run and type the following:
> > "C:\PROGRAM FILES\OUTLOOK EXPRESS\MSIMN.EXE" /reg
> > (Check the path to msimn.exe to make sure that is correct)
> >
> >
> > --
> > Regards Ron de Bruin
> > http://www.rondebruin.nl
> >
> >
> > "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:F27BC477-CD22-43F5-A765-9C85AE9AC72B@microsoft.com...
> > > The send immediately has been checked all along.
> > > --
> > > I B Aver
> > >
> > >
> > > "Excel Ox" wrote:
> > >
> > >> the macro executes to the .send instruction. When it is executed, i get a
> > >> outlook express send-mail window that I have to press send for the message to
> > >> be sent.
> > >> --
> > >> I B Aver
> > >>
> > >>
> > >> "Ron de Bruin" wrote:
> > >>
> > >> > Do you mean that it stay in the outbox ?
> > >> >
> > >> > See Tools>Options>Send in Outlook Express
> > >> >
> > >> > Check : "Send messages immediately"
> > >> >
> > >> > --
> > >> > Regards Ron de Bruin
> > >> > http://www.rondebruin.nl
> > >> >
> > >> >
> > >> > "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:A0215BA3-4A6C-4CB4-9A54-65E2D5CC9DE3@microsoft.com...
> > >> > > Thanks weavtennis. I still get the email page and have to press send.
> > >> > > --
> > >> > > I B Aver
> > >> > >
> > >> > >
> > >> > > "weavtennis" wrote:
> > >> > >
> > >> > >>
> > >> > >> The following works just fine in my '97 version of Excel and V6 OE.
> > >> > >>
> > >> > >>
> > >> > >> Sub Sendemails()
> > >> > >> addy = "myaddress@myISP.com"
> > >> > >> ActiveWorkbook.Sendmail Recipients:=addy
> > >> > >> End Sub
> > >> > >>
> > >> > >> There may be more parameters (like email subject and text in the
> > >> > >> message) - but I get an email in my OE outbox without pressing more
> > >> > >> keys.
> > >> > >>
> > >> > >> If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail
> > >> > >> dialog.
> > >> > >>
> > >> > >>
> > >> > >> --
> > >> > >> weavtennis
> > >> > >> ------------------------------------------------------------------------
> > >> > >> weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
> > >> > >> View this thread: http://www.excelforum.com/showthread...hreadid=514057
> > >> > >>
> > >> > >>
> > >> >
> > >> >
> > >> >
> >
> >
> >

[Excel Ox]

i reloaded outlook express from the cd. No change. how do i go to regular
outlook?
--
I B Aver


"Excel Ox" wrote:

> i finally got it to run by adding a space before the /. the mail page comes
> up smaller now but i still have to press send.
> --
> I B Aver
>
>
> "Excel Ox" wrote:
>
> > I cut and pasted the info in the "run" box and "Program not found" msg. I
> > "Browsed" and found it then added /reg, and "Program not found again". when i
> > remove the /reg, the progam runs.i am sys managed.
> > --
> > I B Aver
> >
> >
> > "Ron de Bruin" wrote:
> >
> > > Strange
> > >
> > > You can try to register OE again
> > >
> > > Go to Start | Run and type the following:
> > > "C:\PROGRAM FILES\OUTLOOK EXPRESS\MSIMN.EXE" /reg
> > > (Check the path to msimn.exe to make sure that is correct)
> > >
> > >
> > > --
> > > Regards Ron de Bruin
> > > http://www.rondebruin.nl
> > >
> > >
> > > "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:F27BC477-CD22-43F5-A765-9C85AE9AC72B@microsoft.com...
> > > > The send immediately has been checked all along.
> > > > --
> > > > I B Aver
> > > >
> > > >
> > > > "Excel Ox" wrote:
> > > >
> > > >> the macro executes to the .send instruction. When it is executed, i get a
> > > >> outlook express send-mail window that I have to press send for the message to
> > > >> be sent.
> > > >> --
> > > >> I B Aver
> > > >>
> > > >>
> > > >> "Ron de Bruin" wrote:
> > > >>
> > > >> > Do you mean that it stay in the outbox ?
> > > >> >
> > > >> > See Tools>Options>Send in Outlook Express
> > > >> >
> > > >> > Check : "Send messages immediately"
> > > >> >
> > > >> > --
> > > >> > Regards Ron de Bruin
> > > >> > http://www.rondebruin.nl
> > > >> >
> > > >> >
> > > >> > "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:A0215BA3-4A6C-4CB4-9A54-65E2D5CC9DE3@microsoft.com...
> > > >> > > Thanks weavtennis. I still get the email page and have to press send.
> > > >> > > --
> > > >> > > I B Aver
> > > >> > >
> > > >> > >
> > > >> > > "weavtennis" wrote:
> > > >> > >
> > > >> > >>
> > > >> > >> The following works just fine in my '97 version of Excel and V6 OE.
> > > >> > >>
> > > >> > >>
> > > >> > >> Sub Sendemails()
> > > >> > >> addy = "myaddress@myISP.com"
> > > >> > >> ActiveWorkbook.Sendmail Recipients:=addy
> > > >> > >> End Sub
> > > >> > >>
> > > >> > >> There may be more parameters (like email subject and text in the
> > > >> > >> message) - but I get an email in my OE outbox without pressing more
> > > >> > >> keys.
> > > >> > >>
> > > >> > >> If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail
> > > >> > >> dialog.
> > > >> > >>
> > > >> > >>
> > > >> > >> --
> > > >> > >> weavtennis
> > > >> > >> ------------------------------------------------------------------------
> > > >> > >> weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
> > > >> > >> View this thread: http://www.excelforum.com/showthread...hreadid=514057
> > > >> > >>
> > > >> > >>
> > > >> >
> > > >> >
> > > >> >
> > >
> > >
> > >

[Ron de Bruin]

Hi

Outlook express is a part of Windows and Outlook a part of Office.

You can change the program for Office like this

Start>Settings>Control Panel....Internet options (Program Tab)
Close Excel first before you make a change.


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


"Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:2BB09E82-0E7A-4A90-B5B5-19975B71E163@microsoft.com...
>i reloaded outlook express from the cd. No change. how do i go to regular
> outlook?
> --
> I B Aver
>
>
> "Excel Ox" wrote:
>
>> i finally got it to run by adding a space before the /. the mail page comes
>> up smaller now but i still have to press send.
>> --
>> I B Aver
>>
>>
>> "Excel Ox" wrote:
>>
>> > I cut and pasted the info in the "run" box and "Program not found" msg. I
>> > "Browsed" and found it then added /reg, and "Program not found again". when i
>> > remove the /reg, the progam runs.i am sys managed.
>> > --
>> > I B Aver
>> >
>> >
>> > "Ron de Bruin" wrote:
>> >
>> > > Strange
>> > >
>> > > You can try to register OE again
>> > >
>> > > Go to Start | Run and type the following:
>> > > "C:\PROGRAM FILES\OUTLOOK EXPRESS\MSIMN.EXE" /reg
>> > > (Check the path to msimn.exe to make sure that is correct)
>> > >
>> > >
>> > > --
>> > > Regards Ron de Bruin
>> > > http://www.rondebruin.nl
>> > >
>> > >
>> > > "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:F27BC477-CD22-43F5-A765-9C85AE9AC72B@microsoft.com...
>> > > > The send immediately has been checked all along.
>> > > > --
>> > > > I B Aver
>> > > >
>> > > >
>> > > > "Excel Ox" wrote:
>> > > >
>> > > >> the macro executes to the .send instruction. When it is executed, i get a
>> > > >> outlook express send-mail window that I have to press send for the message to
>> > > >> be sent.
>> > > >> --
>> > > >> I B Aver
>> > > >>
>> > > >>
>> > > >> "Ron de Bruin" wrote:
>> > > >>
>> > > >> > Do you mean that it stay in the outbox ?
>> > > >> >
>> > > >> > See Tools>Options>Send in Outlook Express
>> > > >> >
>> > > >> > Check : "Send messages immediately"
>> > > >> >
>> > > >> > --
>> > > >> > Regards Ron de Bruin
>> > > >> > http://www.rondebruin.nl
>> > > >> >
>> > > >> >
>> > > >> > "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message
>> > > >> > news:A0215BA3-4A6C-4CB4-9A54-65E2D5CC9DE3@microsoft.com...
>> > > >> > > Thanks weavtennis. I still get the email page and have to press send.
>> > > >> > > --
>> > > >> > > I B Aver
>> > > >> > >
>> > > >> > >
>> > > >> > > "weavtennis" wrote:
>> > > >> > >
>> > > >> > >>
>> > > >> > >> The following works just fine in my '97 version of Excel and V6 OE.
>> > > >> > >>
>> > > >> > >>
>> > > >> > >> Sub Sendemails()
>> > > >> > >> addy = "myaddress@myISP.com"
>> > > >> > >> ActiveWorkbook.Sendmail Recipients:=addy
>> > > >> > >> End Sub
>> > > >> > >>
>> > > >> > >> There may be more parameters (like email subject and text in the
>> > > >> > >> message) - but I get an email in my OE outbox without pressing more
>> > > >> > >> keys.
>> > > >> > >>
>> > > >> > >> If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail
>> > > >> > >> dialog.
>> > > >> > >>
>> > > >> > >>
>> > > >> > >> --
>> > > >> > >> weavtennis
>> > > >> > >> ------------------------------------------------------------------------
>> > > >> > >> weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
>> > > >> > >> View this thread: http://www.excelforum.com/showthread...hreadid=514057
>> > > >> > >>
>> > > >> > >>
>> > > >> >
>> > > >> >
>> > > >> >
>> > >
>> > >
>> > >

[Excel Ox]

Your are great! I have switched over to outlook, and other problems but i'll
go to outlook to solve them. I really appreciate all your help.
--
I B Aver


"Excel Ox" wrote:

> the macro executes to the .send instruction. When it is executed, i get a
> outlook express send-mail window that I have to press send for the message to
> be sent.
> --
> I B Aver
>
>
> "Ron de Bruin" wrote:
>
> > Do you mean that it stay in the outbox ?
> >
> > See Tools>Options>Send in Outlook Express
> >
> > Check : "Send messages immediately"
> >
> > --
> > Regards Ron de Bruin
> > http://www.rondebruin.nl
> >
> >
> > "Excel Ox" <ExcelOx@discussions.microsoft.com> wrote in message news:A0215BA3-4A6C-4CB4-9A54-65E2D5CC9DE3@microsoft.com...
> > > Thanks weavtennis. I still get the email page and have to press send.
> > > --
> > > I B Aver
> > >
> > >
> > > "weavtennis" wrote:
> > >
> > >>
> > >> The following works just fine in my '97 version of Excel and V6 OE.
> > >>
> > >>
> > >> Sub Sendemails()
> > >> addy = "myaddress@myISP.com"
> > >> ActiveWorkbook.Sendmail Recipients:=addy
> > >> End Sub
> > >>
> > >> There may be more parameters (like email subject and text in the
> > >> message) - but I get an email in my OE outbox without pressing more
> > >> keys.
> > >>
> > >> If you need to, use "sendkeys" to send "ALT+ENTER" to the OE mail
> > >> dialog.
> > >>
> > >>
> > >> --
> > >> weavtennis
> > >> ------------------------------------------------------------------------
> > >> weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
> > >> View this thread: http://www.excelforum.com/showthread...hreadid=514057
> > >>
> > >>
> >
> >
> >