| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
i have to press sent to email
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i have to press sent to email
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i have to press sent to email
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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i have to press sent to email
Which mail program do you use
-- Regards Ron de Bruin http://www.rondebruin.nl "Excel Ox" wrote in message ... 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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i have to press sent to email
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" wrote in message ... 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" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i have to press sent to email
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i have to press sent to email
The following works just fine in my '97 version of Excel and V6 OE. Sub Sendemails() addy = " 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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i have to press sent to email
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 = " 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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i have to press sent to email
Do you mean that it stay in the outbox ?
See ToolsOptionsSend in Outlook Express Check : "Send messages immediately" -- Regards Ron de Bruin http://www.rondebruin.nl "Excel Ox" wrote in message ... 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 = " 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 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i have to press sent to email
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 ToolsOptionsSend in Outlook Express Check : "Send messages immediately" -- Regards Ron de Bruin http://www.rondebruin.nl "Excel Ox" wrote in message ... 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 = " 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 |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i have to press sent to email
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 ToolsOptionsSend in Outlook Express Check : "Send messages immediately" -- Regards Ron de Bruin http://www.rondebruin.nl "Excel Ox" wrote in message ... 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 = " 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 |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i have to press sent to email
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 ToolsOptionsSend in Outlook Express Check : "Send messages immediately" -- Regards Ron de Bruin http://www.rondebruin.nl "Excel Ox" wrote in message ... 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 = " 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I Press the Enter Key Nothing happens. | Excel Discussion (Misc queries) | |||
| key press event? | Excel Programming | |||
| on press | Excel Programming | |||
| on press detection | Excel Programming | |||
| test for key press | Excel Programming | |||
Hybrid Mode
