View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Beverly[_3_] Beverly[_3_] is offline
external usenet poster
 
Posts: 9
Default Mailing Excel workbooks that are not active workbook

Hi Ron
Sorry to be such a pest. It looks like my lotus mail server supports tcpip, nds and netbios. I see nothing about smtp. However, we can access our mail from a webserver. I inserted my .nsf path as follows, but get a message that "the transport failed to connect to server.

here is the code where I inserted my text
Set Flds = iConf.FIELD
With Fld

.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") =
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.ilsirusntsm1/mail/BeverlyMcDowell.nsf
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 2
.Updat
End Wit

With iMs
Set .Configuration = iCon
.To = "Beverly
.From = """Beverly""
.Subject = "This is a test
.TextBody = "Hi there
' .AddAttachment "C:\bev\" & WBnam
.AddAttachment "C:\bev\bystry.xls
' You can add any file you want with this line .AddAttachment "C:/Test.txt
.SEN

Thanks again for your effort
-Beverly