vb forms excel
The Internet's
Leading Tax Reduction Expert reveals
just how easy (and legal) it is
to reduce your taxes
by $2,000 ... $3,000 ... $4,000 or more --GUARANTEED!
Click Here Now!
Make command button in Excel VB open new message in Outlook.
Hello, I have a userform created in Visual Basic, with Microsoft Excel. I would add a command button to the form to open a new mail message from Microsoft Office Outlook 2003. I do not want that fill the "To:" address field or body of the message … just to open a new blank message. Would we be able to help me? Thank you.
Private Sub CommandButton1_Click () Dim Sun oOLook As Object = CreateObject oEMail As oOLook set ("Outlook.Application") Set oOLook.Session.Logon oEMail = 'OOLook.CreateItem Object (0) oEMail.Display "On Error Resume Next' With oEMail. To = "JohnDoe@Yahoo.mail. CC = "" '. BCC = "" '. Subject = "This is the Subject line. Body = "Hello". "Send" End With 'On Error GoTo 0 'End Sub
