ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SendMail (https://www.excelbanter.com/excel-programming/330116-sendmail.html)

upstate_steve

SendMail
 

I'm using Excel 97. Can anyone get me started in the right direction
with the SendMail method?

The MailSystem property returns xlNoMailSystem.

I have both Lotus Notes 5.0.8 and Outlook Express 5 installed on my
computer.

I'm trying to write a procedure that breaks up a database and mails
each segment to the recipient indicated by the data.

Thanks

Steve


--
upstate_steve
------------------------------------------------------------------------
upstate_steve's Profile: http://www.excelforum.com/member.php...fo&userid=8116
View this thread: http://www.excelforum.com/showthread...hreadid=374000


upstate_steve[_2_]

SendMail
 

To clarify, I don't need any help with the code; just need to ge
oriented on how to get Excel to talk to Lotus or Outlook, if possible.
The "Send To" submenu alluded to in Excel help is absent in m
application

--
upstate_stev
-----------------------------------------------------------------------
upstate_steve's Profile: http://www.excelforum.com/member.php...nfo&userid=811
View this thread: http://www.excelforum.com/showthread.php?threadid=37400


Ron de Bruin

SendMail
 
See
http://www.rondebruin.nl/mail/problems.htm


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



"upstate_steve" wrote in message
news:upstate_steve.1plpvk_1117047664.8335@excelfor um-nospam.com...

I'm using Excel 97. Can anyone get me started in the right direction
with the SendMail method?

The MailSystem property returns xlNoMailSystem.

I have both Lotus Notes 5.0.8 and Outlook Express 5 installed on my
computer.

I'm trying to write a procedure that breaks up a database and mails
each segment to the recipient indicated by the data.

Thanks

Steve


--
upstate_steve
------------------------------------------------------------------------
upstate_steve's Profile: http://www.excelforum.com/member.php...fo&userid=8116
View this thread: http://www.excelforum.com/showthread...hreadid=374000




Alex J

SendMail
 
Steve,
For Lotus notes, try a Google on Sending Email using Lotus Notes, a reply I
posted in July '03.
Alex J

"upstate_steve"
wrote in message
news:upstate_steve.1plpvk_1117047664.8335@excelfor um-nospam.com...

I'm using Excel 97. Can anyone get me started in the right direction
with the SendMail method?

The MailSystem property returns xlNoMailSystem.

I have both Lotus Notes 5.0.8 and Outlook Express 5 installed on my
computer.

I'm trying to write a procedure that breaks up a database and mails
each segment to the recipient indicated by the data.

Thanks

Steve


--
upstate_steve
------------------------------------------------------------------------
upstate_steve's Profile:

http://www.excelforum.com/member.php...fo&userid=8116
View this thread: http://www.excelforum.com/showthread...hreadid=374000




upstate_steve[_3_]

SendMail
 

Upon further investigation, I have found that on my machine Microsof
Word can open Lotus with the "Send To" submenu command, but Exce
cannot. Anyone know why?

Thanks
Stev

--
upstate_stev
-----------------------------------------------------------------------
upstate_steve's Profile: http://www.excelforum.com/member.php...nfo&userid=811
View this thread: http://www.excelforum.com/showthread.php?threadid=37400



All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com