Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am getting a type definition error on the first two DIM statements
Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(olMailItem) With OutMail ..To = StudenteMail ..CC = "" ..BCC = "" ..Subject = "Class Progress Audio Report for " & Date Dim strbody As String strbody = "Outstanding job today. Please keep up the great work " & StudentName & vbNewLine & vbNewLine & _ "Kind regards" & vbNewLine & _ "Me" ..Attachments.Add ("C:\Cantillation Sounds\InstructorNotes.wav") ..Display End With Set OutMail = Nothing Set OutApp = Nothing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
will a macro transfer to another computer if I e-mail the file? | Excel Discussion (Misc queries) | |||
Need help with mail merge - excel 2003 to word 2003 please.. | Excel Discussion (Misc queries) | |||
play wave file from Excel 2003 macro | Excel Programming | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) |