Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the correct as I want it but is there a way I can have the cursor
positioned in the Subject line after the file name? (Is this even possible?) ------------------- Sub SendWithAtt() Dim olApp As Outlook.Application Dim olMail As MailItem Dim CurrFile As String Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) ActiveWorkbook.Save CurrFile = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name With olMail .To = " .Subject = ActiveSheet.Range("d1").Text .Attachments.Add CurrFile .Display '.Send End With Set olMail = Nothing Set olApp = Nothing End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subject from Outlook to Excel | Excel Discussion (Misc queries) | |||
Push Button in Outlook to Change Focus to Outlook Contact List | Excel Programming | |||
Populate the subject line. | Excel Worksheet Functions | |||
Subject line in outlook | Excel Programming | |||
Subject line in E-mail | Excel Programming |