Emailing an User Input form from Excel

[Jaime]

Hi to all,

Here's the situation. I created a form in Excel in which I
want users to provide their input. I don't want to email
the spreasheet, Just the Input. I've been using this code
but it mails out the spreasheet aswell (I don't want to
email the spreasheet). Can someone telll me what I'm doing
wrong?
Thanks in Advanced!

Here's the code
=====================
ActiveWorkbook.HasRoutingSlip = True
With ActiveWorkbook.RoutingSlip

.Recipients = "Email Address"
.Subject = Subj
.Message = All
.Delivery = xlAllAtOnce
.ReturnWhenDone = False
.ReturnWhenDone = True
.TrackStatus = True
End With
Application.ScreenUpdating = True
ActiveWorkbook.Route
===================================

Thanks in Advance!

 

[Michael Solomon \(MS-MVP Windows Shell/User\)]

Go to the following website, scroll the list on the left to Excel, select
the most appropriate seeming Excel group if there's more than one and try
posting your question there:
http://communities.microsoft.com/newsgroups/default.asp