Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use Outlook express to send mail rather than Outlook by VBA code
How can I use Outlook express to send mail rather than Outlook by VBA code
thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use Outlook express to send mail rather than Outlook by VBA code
Have you seen my reply and try it ?
-- Regards Ron de Bruin http://www.rondebruin.nl "new.microsoft.com" wrote in message ... How can I use Outlook express to send mail rather than Outlook by VBA code thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use Outlook express to send mail rather than Outlook by VBA code
Thank you very much Ron,
Yes, but i don't understand how the Outlook Express can be called rather than Outlook as creat object only has the outlook and no outlook express. "Ron de Bruin" wrote in message ... Have you seen my reply and try it ? -- Regards Ron de Bruin http://www.rondebruin.nl "new.microsoft.com" wrote in message ... How can I use Outlook express to send mail rather than Outlook by VBA code thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use Outlook express to send mail rather than Outlook by VBA code
Hi
You must use SendMail code If you want to use OE and not the Outlook object model -- Regards Ron de Bruin http://www.rondebruin.nl "new.microsoft.com" wrote in message ... Thank you very much Ron, Yes, but i don't understand how the Outlook Express can be called rather than Outlook as creat object only has the outlook and no outlook express. "Ron de Bruin" wrote in message ... Have you seen my reply and try it ? -- Regards Ron de Bruin http://www.rondebruin.nl "new.microsoft.com" wrote in message ... How can I use Outlook express to send mail rather than Outlook by VBA code thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use Outlook express to send mail rather than Outlook by VBA code
I see. Ron do you know why my following code doesn't work? The mail just
displayed but not send out. Thanks Sub SendWithAtt() Dim olApp As Outlook.Application Dim olMail As MailItem Dim CurrFile As String Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) ActiveWorkbook.Save ' CurrFile = ActiveWorkbook.path & "\" & ActiveWorkbook.Name CurrFile = ActiveWorkbook.path & "\" & "OSAllowRates.pdf" With olMail .To = " '.CC = "" .Subject = "Testing" .Body = "Hello" .Attachments.Add CurrFile .Display ' End With Application.SendKeys "%S" Set olMail = Nothing Set olApp = Nothing End Sub "Ron de Bruin" wrote in message ... Hi You must use SendMail code If you want to use OE and not the Outlook object model -- Regards Ron de Bruin http://www.rondebruin.nl "new.microsoft.com" wrote in message ... Thank you very much Ron, Yes, but i don't understand how the Outlook Express can be called rather than Outlook as creat object only has the outlook and no outlook express. "Ron de Bruin" wrote in message ... Have you seen my reply and try it ? -- Regards Ron de Bruin http://www.rondebruin.nl "new.microsoft.com" wrote in message ... How can I use Outlook express to send mail rather than Outlook by VBA code thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use Outlook express to send mail rather than Outlook by VBA code
Be sure thet the VBA editor is closed when you try it
You can try this Before the sendkeys line Application.Wait (Now + TimeValue("0:00:03")) Remember thet sendkeys is not reliable If you can use CDO then use that http://www.rondebruin.nl/cdo.htm -- Regards Ron de Bruin http://www.rondebruin.nl "new.microsoft.com" wrote in message ... I see. Ron do you know why my following code doesn't work? The mail just displayed but not send out. Thanks Sub SendWithAtt() Dim olApp As Outlook.Application Dim olMail As MailItem Dim CurrFile As String Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) ActiveWorkbook.Save ' CurrFile = ActiveWorkbook.path & "\" & ActiveWorkbook.Name CurrFile = ActiveWorkbook.path & "\" & "OSAllowRates.pdf" With olMail .To = " '.CC = "" .Subject = "Testing" .Body = "Hello" .Attachments.Add CurrFile .Display ' End With Application.SendKeys "%S" Set olMail = Nothing Set olApp = Nothing End Sub "Ron de Bruin" wrote in message ... Hi You must use SendMail code If you want to use OE and not the Outlook object model -- Regards Ron de Bruin http://www.rondebruin.nl "new.microsoft.com" wrote in message ... Thank you very much Ron, Yes, but i don't understand how the Outlook Express can be called rather than Outlook as creat object only has the outlook and no outlook express. "Ron de Bruin" wrote in message ... Have you seen my reply and try it ? -- Regards Ron de Bruin http://www.rondebruin.nl "new.microsoft.com" wrote in message ... How can I use Outlook express to send mail rather than Outlook by VBA code thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fw: send two or more files with Excel and Outlook Express | Excel Discussion (Misc queries) | |||
How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
Cannot send out Excel workbook through Outlook Express | Excel Programming | |||
Send to Outlook 2000 not Outlook Express | Excel Discussion (Misc queries) | |||
Display mail application either in Outlook, or Outlook express | Excel Programming |