Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi,
i have set a form up in excel and created a command button to email the completed form back. there is an option for a new email message in outlook to have a voting component, such as approve or reject. how do i add this command to the below macro? Private Sub CommandButton1_Click() Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) With OutMail ..To = "" ..CC = "" ..BCC = "" ..Subject = "Order" ..Body = "" ..Attachments.Add ActiveWorkbook.FullName ..display End With Set OutMail = Nothing Set OutApp = Nothing End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
Macro email | Excel Programming | |||
Email Macro | Excel Programming | |||
Excel VBA macro to send email attachment from default email client | Excel Programming | |||
How do I create an email macro to auto fill the email? | Excel Discussion (Misc queries) |