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

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

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

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

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