I am creating a userform for tracking purposes. I know that you can set a spreadsheet to automatically route a copy of the spreadsheet to an email address. However, I do not want it to route the entire spreadsheet everytime someone makes an entry. I just need it to route a copy of the entry. Is there a way to route just a copy of the entry?

Thanks
Pam

When you say route a copy of the entry do you mean the values entered into
the userform ?

If you do not route the entire sheet then you must create a sheet with just
the entry on and send this, but how does the recepient know what to do with
it? What about sending the userform values in a body text of an email?

Sub MailUpdate()
'You must add a reference to the Microsoft outlook Library
Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)
With OutMail
.To = "
.CC = ""
.BCC = ""
.Subject = "Entry Update"
.Body = "This is an automated email - new entry is:" & VbCrLf &
userform1.textbox1.value
.Send
End With
Set OutMail = Nothing
Set OutApp = Nothing
End Sub

Cheers
Nigel

"RayzGurl" wrote in message
...
I am creating a userform for tracking purposes. I know that you can set a
spreadsheet to automatically route a copy of the spreadsheet to an email
address. However, I do not want it to route the entire spreadsheet everytime
someone makes an entry. I just need it to route a copy of the entry. Is
there a way to route just a copy of the entry?

Thanks
Pam




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---