Need some Excel Help (emials from speadsheet)?

Question

hey guys, i need some help with an excel document im trying to make

its a short and sweet, but its for my job

just having fields:

Name

Number

Service Eligibility (DSL, Uverse, and Home Phone) With a drop down box for each (Yes, No , Existing)

then the reason they are here:

i can do all that fine, but what im having trouble with is i want 5 buttons under that will it will send to a different persons e-mail threw outlook when the corrisponding button is pressed... i dont know how to make that macro, any assistance would be great!

thanks

Kyle

Answer 1

The code below is a sample of what you need in Excel 2003 to send email through Outlook.

Sub SendMsg()

    Dim oNotice As MailItem

    Set oNotice = CreateItem(olMailItem)

    oNotice.To = "email address 1"

    oNotice.CC = "email address 2"

    oNotice.Subject = "Test Message”

    oNotice.Body = "This message was sent as a test."

    oNotice.Send

    Set oNotice = Nothing

End Sub

Excel 2007 should be the same or very similar.