Copy a sheet to the body of an email or attach part of a spreadsheet
 

Hi,

Can anyone shed any light on this please.

I have a spreadsheet which i want to either attach 1 sheet of it to an
email, or copy the range to the body of the email.

I want to select recipients manually and send manually.

I need to do this in Lotus notes and outlook express

Copy a sheet to the body of an email or attach part of a spreadsheet
 

Hi David,

try

Workbooks("abcd.xls").SendMail

This should work with both Notes and Outlook depending
which is your standard mail tool.

Best

Markus


-----Original Message-----
Hi,

Can anyone shed any light on this please.

I have a spreadsheet which i want to either attach 1
sheet of it to an
email, or copy the range to the body of the email.

I want to select recipients manually and send manually.

I need to do this in Lotus notes and outlook express


.