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

  • Thread starter Thread starter David
  • Start date Start date
D

David

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
 
Hi David,

try

Workbooks("abcd.xls").SendMail

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

Best

Markus
 
Back
Top