Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi -- May I request your help. Few of my clients have their mailsystem
as Lotus Notes. I am trying to send thw workbook automatically using Lotus notes. I have never used/worked in Lotus Notes thus am not familiar with the same. Below is my code for outlook. Currently i have just added a msg saying outlook not configured. filenametemp = strFolderPath & filename Application.DisplayAlerts = False ActiveWorkbook.SaveAs filename:=filenametemp filename = ActiveWorkbook.FullName 'Check the Mailsystem Select Case Application.MailSystem Case xlMAPI ActiveWorkbook.SendMail " Case xlPowerTalk MsgBox "Outlook is not configured. Please send the email by attaching the file directly from “&filename Case xlNoMailSystem MsgBox "No mail system installed! Please send the email by attaching the file directly from " & filename End Select MsgBox "Thank You." & vbCrLf & "" & vbCrLf & "Work Request has been Saved in " & filename Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VIA Excel - Composing a Lotus Notes email without sending | Excel Programming | |||
Sending An Email To Web-Based Lotus Notes 7 | Excel Discussion (Misc queries) | |||
Mail über Lotus Notes aus Excel heraus/ Sending Mail with Excel through Lotus Notes | Excel Programming | |||
sending bitmaps through Lotus notes | Excel Programming | |||
Sending Email using Lotus Notes | Excel Programming |