ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Set focus on Subject line in Outlook (https://www.excelbanter.com/excel-programming/376025-set-focus-subject-line-outlook.html)

Annette

Set focus on Subject line in Outlook
 
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




All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com