Outlook 2007+ Changing signature also changes subject?

Status
Not open for further replies.

X82

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
I'm hoping someone can help.

Currently I use a series of signatures to reply to emails. New rules have come in at work, meaning that instead of the subject reading "RE: Info" or "RE: RE: RE:" I must change it to a pre-set sentence like Authorisation 0054213 . The number will change but the first part is always the same. Is there a way of making outlook change the subject line in the email, when I change the signature?

Even better, would be a script to take a 9 digit code in the body of the email which my signature currently produces and inserts that into the subject also. Can any of this be done?
 

Forum Admin

Senior Member
Signature question: no, you can't change the signature and subject at once.

You can use VBA to change the subject and can use it to pick up the number, if its easily parsed, i.e., is always in the body as "Auth code 123456789" or something like that that can easily be searched for.

Parsing text fields in Outlook - Slipstick Systems

Add a file number or keyword to the subject line of messages - Slipstick Systems - this is a VBA sample that you'd run on the message. You could also use an "ItemSend" macro to add the code as the message is sent.
 

X82

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Perhaps, is there a way instead, of having a drop down menu. I can chose from a pre-set list of subjects and chose one to send to clients? Can this be done instead? So I hit reply to all, chose a new subject and chose my signature and send. This would be easier than the current system in place. This possible?
 

X82

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Wow thats very kind of you. I shall look forward to it!
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
it's quick and dirty - a more complicated custom dialog would be better, but this is faster. Enter the desired subjects in the case statements - if you want to keep the original subject, use this format: oMail.Subject = "Code1 " & objItem.Subject

In Outlook 2013, signature switching doesn't work for plain text. That's where you click on a signature and choose a different one. Changing the account via code doesn't change the signature, you'll need to change it yourself.

It uses the getcurrentitem function at Outlook VBA: work with open item or selected item - Slipstick Systems so it works on open or selected messages.

Code:
Public Sub New_Reply() 
 
Dim objItem As Object 
 
Dim oMail As Outlook.MailItem 
 
Dim oAccount As Outlook.Account 
 
Dim strbox 
 
Set objItem = GetCurrentItem()
   Set oMail = Application.ActiveExplorer.Selection(1).Reply 
 
oMail.Display 
 
strbox = InputBox("Enter the subject - 1:Code1; 2:Code2; default is unknown", "Subject", "") 
 
Select Case LCase(strbox)
   Case "1"
       oMail.Subject = "Code1"
   Case "2"
      oMail.Subject = "Code2"
   Case Else
      oMail.Subject = "Unknown" 
 
End Select
  
 
End Sub
 

X82

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Thanks for this. sorry to be a pain, but I'm not quite sure how to implement this.

I open vba and paste this in a module? Then run it as a macro? Sorry to be a pain.
 

X82

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Apologies. I couldn't find an edit post button.

Managed to get it to work and it works great. Only thing I would say, would it be possible instead of a press 1,2 or 3, there would be a drop down menu which would appear?
 

X82

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Thats fantastic. Just what I needed!
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
B Problemss when changing from pop3 to imap email accounts in Outlook 2007 Using Outlook 2
P Changing all email signatures (font, color) at once in outlook 2007 Using Outlook 2
J Move PST /changing default location in Outlook 2007 or 2010 64b on W7 64bit Using Outlook 2
J Outlook 2007 Proxy settings changing back to one of our domains Using Outlook 2
G E2k7 | After changing OAB on database properties, how much time it will take for Outlook 2007 to download new OAB Using Outlook 2
J Changing Font color in Outlook 2007 Using Outlook 2
B Outlook 2007 - Contacts File As: is randomly changing... Using Outlook 1
G Outlook 2007 - Contact phone number fields - changing names Using Outlook 2
M Changing to Microsoft Outlook 2010 from Windows Live 2007 Using Outlook 1
R Changing the default message form in Outlook 2007 Outlook VBA and Custom Forms 1
S Verwendung von Outlook 2007 Using Outlook 0
A Arthur needs help with 2007 Outlook e-mail Using Outlook.com accounts in Outlook 3
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
S outlook 2007 calendar search Using Outlook 6
B Migrate Outlook 2007 to Office 365 Using Outlook 3
X I have met my waterloo trying to resolve embedded graphics problem with outlook 2007 and now 2016 Using Outlook 1
R Outlook 2007 only loads some appointments Using Outlook 0
C Move Outlook 2007 to new PC with Outlook 365 Using Outlook 3
J Outlook 2007 Hide Messages Option not Available Using Outlook 2
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 4
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 0
B Server errors Outlook 2007 Using Outlook 1
S Reboot of frozen windows7 results in changed outlook 2007 settings Using Outlook 1
S Outlook 2007 printing wrong email address at top of page Using Outlook 8
M Configure outlook 2007 to accept digital signatures Using Outlook 2
D Outlook 2007 crashes when opening an email Using Outlook 2
R New chap saying hello and needing advice on Outlook 2007 thumbnails Using Outlook 3
icacream From Outlook 2007 to 2016 ! Using Outlook 9
vodkasoda Object could not be found Error in Outlook 2007 Outlook VBA and Custom Forms 5
S Outlook 2007: Address Cards allow entering text! Why? Using Outlook 3
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
L Outlook 2007 Separate the Send/Receive functions Using Outlook 2
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
C Move from Outlook 2007 Enterprise (MOE) to Outlook Pro plus 2007 Using Outlook 1
J reinstalling Outlook 2007 asking for user name & password Using Outlook 14
P outlook addin unloaded in office 2007 Using Outlook 0
B Fonts in Outlook 2007 Using Outlook 4
R Add Exchange Account to existing POP3 Outlook 2007 Profile Using Outlook 0
C out of space in file group Outlook 2007 Using Outlook 2
A Moving archived contents in Outlook 2007 back into working folders Using Outlook 0
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
M Unable to Configure Gmail Account in Outlook 2007 Using Outlook 1
R Outlook 2007 or 2010 - Lock Down Functionality Outlook VBA and Custom Forms 3
S Outlook 2007, windows 10 Font size Using Outlook 1
Diane Poremsky Manually create a POP3 account in Outlook 2007 New Slipstick.com Articles 0
J Can Click to Drag Custom Form Field But Cannot Drop When Designing in Outlook 2007 Outlook VBA and Custom Forms 2
L Outlook 2007 Font Using Outlook 3
J Outlook 2007 connector and Windows 10 Using Outlook 3
R Outlook 2007 - Shared Accounts and Resources without Exchange Server Using Outlook 0
L Outlook 2007 - Macro Re Search Using Outlook 16
Similar threads


















































Top