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

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

got it perfect

thanks
--
Kevin


"Ron de Bruin" wrote:

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