Creating UserForms in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 = "(e-mail address removed)"
.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 said:
I am creating a userform for tracking purposes. I know that you can set a
Click to expand...
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?
 
Back
Top