View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Attach File to a Lotus Notes new email

See Dennis his site for Lotus code (third link)
http://www.rondebruin.nl/mail/links.htm

Another way is to use CDO
http://www.rondebruin.nl/cdo.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kevin" wrote in message ...
Hi

I usel Excel 2002 and Lotus Notus Notes 6.5. When Outlook is available
usually Excel has a function "EmailAs" to attach the current workbook to a
new email - you then enter address, subject etc. I would like some code to
allow me do the same with Lotus Notes.

Specifically;
Save Current Workbook
Attach Current Workbook to new email in Lotus Notes (checking Lotus Notes is
open and opening, prompting for password etc)
Setting the Lotus Notes email subject to the name of the workbook
Moving Focus to the new Lotus Notes email (ie I then add address etc)

Is there any code that you can point me to do this.

thanks


--
Kevin