i have a piece of code below which will email the current .xls file to everyone whos email address is in a range of cells specified
my problem is how can i email a particular sheet instead of the whole workbook?
This message was edited by ass98 on 2002-09-01 13:00
Sub Send_email()
Application.Dialogs(xlDialogSendMail).Show arg1:=Range("E3:E100").Value
End Sub
my problem is how can i email a particular sheet instead of the whole workbook?
This message was edited by ass98 on 2002-09-01 13:00