asked on VBA to insert text in subject line in Outlook
Hi,
Found a bit of VBA code to place text in the subject line of Outlook:
Sub New_Subject_Email()
Dim MItem As MailItem
Set MItem = Application.CreateItem(olM
MItem.subject = "36355 XXXXXXXXXX - "
MItem.Display
End Sub
It Works, but I would love to have the cursor ready (blinking) to type after the "36355 XXXXXXXXXX - " when I use the TAB key to activate the Subject line.
How would I change the VBA code accordingly?
Found a bit of VBA code to place text in the subject line of Outlook:
Sub New_Subject_Email()
Dim MItem As MailItem
Set MItem = Application.CreateItem(olM
MItem.subject = "36355 XXXXXXXXXX - "
MItem.Display
End Sub
It Works, but I would love to have the cursor ready (blinking) to type after the "36355 XXXXXXXXXX - " when I use the TAB key to activate the Subject line.
How would I change the VBA code accordingly?
OutlookVBA
Last Comment
Daniel Pineault
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I am curious as to why you wouldn't just use a quick step to autofill the subject and any other info
ASKER
Hi Daniel,
Checked it out, problem is that you come directly to the subject line, I would rather start with receiver name, use TAB key to move downwards and when in subject line, cursor ready to start typing after the pre-typed text.
I'm a project director and have several projects with different project numbers and names, having always project number and name I can sort the mails automatically, hence the question.
Brgds
Jesper
Checked it out, problem is that you come directly to the subject line, I would rather start with receiver name, use TAB key to move downwards and when in subject line, cursor ready to start typing after the pre-typed text.
I'm a project director and have several projects with different project numbers and names, having always project number and name I can sort the mails automatically, hence the question.
Brgds
Jesper
ASKER
Hi Karen,
Quick step works fine, but as above, I would like to have cursor ready to type when I, by using TAB key, reaches down to Subject line and have cursor ready after the text already inserted by code.
Brgds
Jesper
Quick step works fine, but as above, I would like to have cursor ready to type when I, by using TAB key, reaches down to Subject line and have cursor ready after the text already inserted by code.
Brgds
Jesper
ASKER
HI,
Above code works fine, only I need the addition to get the cursor ready to type and the end of the text already placed in the subject line, when the subject line gets focus by jumping down using TAB key.
Brgds
Jesper
Above code works fine, only I need the addition to get the cursor ready to type and the end of the text already placed in the subject line, when the subject line gets focus by jumping down using TAB key.
Brgds
Jesper
ASKER
No solution found for having cursor ready at the end of the pre-printed text in the subject line.
As I originally stated, I think you'd have to get into using windows APIs for this.