Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2440
  • Last Modified:

Insert signature in Outlook 2003 at users cursor via VBA

I have found how to insert a signature using VBA and it works fine.  But, now I was wondering if it is possible to insert the signature at the users cursor in the email.  Currently the signature appends to the bottom of the email, but my users are now having difficulty with it when they reply or forward emails.  So, I would like to see if I can insert the signature where the user has but the cursor instead of appending it at the bottom of the email.

Below is the current code I have for the signatures.  One method I have used to insert text in the path was the "SendKey" function in VBA, but I am not sure how to do this with signatures.
Sub InsertSignature()
    Dim objFSO As Object, _
        objShell As Object, _
        objSignatureFile As Object, _
        olkMsg As Outlook.MailItem, _
        strSigFilePath As String, _
        strBuffer As String
    Set olkMsg = Application.ActiveInspector.CurrentItem
    Set objShell = CreateObject("Wscript.Shell")
    strSigFilePath = objShell.SpecialFolders("Desktop")
    If InStr(1, WinVer(), "Vista") Then
        strSigFilePath = Replace(strSigFilePath, "Desktop", "AppData\Roaming\Microsoft\Signatures\")
    Else
        strSigFilePath = Replace(strSigFilePath, "Desktop", "Application Data\Microsoft\Signatures\")
    End If
    Set objFSO = CreateObject("Scripting.FileSystemObject")
    'Edit the signature file name on the following line as needed'
    Set objSignatureFile = objFSO.OpenTextFile(strSigFilePath & "NXW-FIRM.htm")
    strBuffer = objSignatureFile.ReadAll
    objSignatureFile.Close
    olkMsg.HTMLBody = olkMsg.HTMLBody & strBuffer
    Set objSignatureFile = Nothing
    Set objFSO = Nothing
    Set objShell = Nothing
    Set olkMsg = Nothing
End Sub
 
Function WinVer() As String
    Dim objShell As Object, strOS As String, strKey As String
    Set objShell = CreateObject("WScript.Shell")
    strOS = objShell.ExpandEnvironmentStrings("%OS%")
    If strOS = "Windows_NT" Then
        strKey = "HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\"
        WinVer = objShell.RegRead(strKey & "ProductName") & " " & objShell.RegRead(strKey & "CurrentVersion") & "." & objShell.RegRead(strKey & "CurrentBuildNumber")
    Else
        strKey = "HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\"
        WinVer = objShell.RegRead(strKey & "ProductName") & " " & objShell.RegRead(strKey & "VersionNumber")
    End If
    Set objShell = Nothing
End Function

Open in new window

0
navid86
Asked:
navid86
  • 4
  • 4
2 Solutions
 
David LeeCommented:
Hi, navid86.

You can't use this kind of script to insert text at the cursor location in Outlook 2003 because Outlook doesn't expose the cursor location.  SendKeys will work, but it limits you to plain text, no HTML or graphics.  There might be another way to accomplish this, but I'll have to test my theory before I know for sure.
0
 
navid86Author Commented:
Okay, thanks!

Hope to hear from you soon!
0
 
David LeeCommented:
Ok, I figured a way to do this.  First, add the code below to that you already have.  Second, go to this Microsoft page (http://support.microsoft.com/kb/274326) and copy all the code under step 4.  Create a new module in Outlook and paste the code into it.  You're ready to go.

Now when you're editing a message you can insert the signature at the current cursor location by running the InsertSigAtCursor macro.  This works by copying the signature to the clipboard, then using paste to insert it.  Paste always inserts at the current cursor location, so we don't need to know where it's at to get this to work.
Sub InsertSigAtCursor()
    CopySigToClipboard
    SendKeys "+{INSERT}"
End Sub
 
Sub CopySigToClipboard()
    Dim objFSO As Object, _
        objShell As Object, _
        objSignatureFile As Object, _
        strSigFilePath As String, _
        strBuffer As String
    Set olkMsg = Application.ActiveInspector.CurrentItem
    Set objShell = CreateObject("Wscript.Shell")
    strSigFilePath = objShell.SpecialFolders("Desktop")
    If InStr(1, WinVer(), "Vista") Then
        strSigFilePath = Replace(strSigFilePath, "Desktop", "AppData\Roaming\Microsoft\Signatures\")
    Else
        strSigFilePath = Replace(strSigFilePath, "Desktop", "Application Data\Microsoft\Signatures\")
    End If
    Set objFSO = CreateObject("Scripting.FileSystemObject")
    'Edit the signature file name on the following line as needed'
    Set objSignatureFile = objFSO.OpenTextFile(strSigFilePath & "NXW-FIRM.htm")
    strBuffer = objSignatureFile.ReadAll
    objSignatureFile.Close
    PutHTMLClipboard strBuffer, "", ""
    Set objSignatureFile = Nothing
    Set objFSO = Nothing
    Set objShell = Nothing
    Set olkMsg = Nothing
End Sub

Open in new window

0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
navid86Author Commented:
Sweet man!!! Works like a Charm!! I wish I could give you more than the 500 points for this!!

I do have a simple question though.  The code that I copied from Microsoft into a new module comes up as a macro name, "CopySigtoClipboard".  Is there anyway I can hide this from the Macro list?

Thanks again for everything!!
0
 
David LeeCommented:
Thanks for the thought.

Actually, CopySigToClipboard is part of my code.  Yes, if you want to get rid of that, then we can combine it and InsertSigAtCursor.  Replace those two routines with the one combined routine below.
Sub InsertSigAtCursor()
    Dim objFSO As Object, _
        objShell As Object, _
        objSignatureFile As Object, _
        strSigFilePath As String, _
        strBuffer As String
    Set olkMsg = Application.ActiveInspector.CurrentItem
    Set objShell = CreateObject("Wscript.Shell")
    strSigFilePath = objShell.SpecialFolders("Desktop")
    If InStr(1, WinVer(), "Vista") Then
        strSigFilePath = Replace(strSigFilePath, "Desktop", "AppData\Roaming\Microsoft\Signatures\")
    Else
        strSigFilePath = Replace(strSigFilePath, "Desktop", "Application Data\Microsoft\Signatures\")
    End If
    Set objFSO = CreateObject("Scripting.FileSystemObject")
    'Edit the signature file name on the following line as needed'
    Set objSignatureFile = objFSO.OpenTextFile(strSigFilePath & "NXW-FIRM.htm")
    strBuffer = objSignatureFile.ReadAll
    objSignatureFile.Close
    PutHTMLClipboard strBuffer, "", ""
    Set objSignatureFile = Nothing
    Set objFSO = Nothing
    Set objShell = Nothing
    Set olkMsg = Nothing
    SendKeys "+{INSERT}"
End Sub

Open in new window

0
 
navid86Author Commented:
Works AMAZING!
Thank you sooo much for your help!!

0
 
navid86Author Commented:
Thanks a lot for your help!  I have noticed that you have helped on some of my past issues and I really like how you follow through till the issue is complete!!!

Thanks

0
 
David LeeCommented:
Thanks and you're welcome.  Always happy when I can help out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now