Archive

Posts Tagged ‘programming’

vb forms excel

August 30th, 2010 admin No comments




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!
 

Accept Credit Cards 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


Categories: Forms Tags: , , , ,