I want to program in VBA at the press of a button to send the Excel
range selected as a workbook attachment to Lotus Notes users.

Thanks
Simon

I think that you'll have to save the range as a workbook
and then send the workbook.

To save the activeworkbook you can use:
ActiveWorkbook.SaveAs Filename:="SendRange.xls", _
FileFormat:=xlNormal, Password:="", _
WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

To send the active workbook:
ActiveWorkbook.SendMail _
", _
Subject:="Selected Range"

-----Original Message-----
I want to program in VBA at the press of a button to
send the Excel
range selected as a workbook attachment to Lotus Notes
users.

Thanks
Simon
.

Simon,
Check out

http://groups.google.com/groups?hl=n...llglob al.com

Note: This topic has been discussed at least twice in the last year. You
might want to do a google search on newsgroups to find answers!

Alex J

"Simon Lenn" wrote in message
m...
I want to program in VBA at the press of a button to send the Excel
range selected as a workbook attachment to Lotus Notes users.

Thanks
Simon