VBA code to insert custom signature in Outlook 2007 email

Question

I need to insert a specific signature into an email message. Our support team uses a variety of different signatures to respond to different types of support needs. Currently, I access them via the menu: Insert > Signature > "Ticket Assigned - AppSup"

I would like to streamline that process by using a macro instead (I can then create toolbar items for macros to call specific signatures). So, for example, I need VBA code to insert the "Ticket Assigned - AppSup" signature.

Answer 1

Instead of wiring up macros, perhaps check out Outlook 2007's Quick Parts.

The Microsoft Office Outlook 2007 Quick Parts feature provides building blocks, reusable pieces of content or other e-mail message parts that are stored in galleries. You can access and reuse the building blocks at any time. You can also save building blocks and distribute them with templates so that other users can use the building blocks you created.

Create a reusable building block:

1. Select the content or e-mail message part that you want to store as a reusable building block.
2. On the Insert tab, in the Text group, click Quick Parts.
3. Click Save Selection to Gallery Name Gallery.
4. Fill out the information in the Create New Building Block dialog box.

You can insert a Quick Part by selecting it form the Ribbon, or start typing the Quick Part name and hit F3.

Answer 2

If you want to use macros instead of Quick Parts, here's some info to get you going.

An example VBA function to insert text intot eh current edit window of Outlook:

Public Sub MySig1()
  Set objDoc = Application.ActiveInspector.WordEditor
  Set objSel = objDoc.Windows(1).Selection
  objSel.TypeText Text:=vbCrLf & "Joe Blow" & vbCrLf & "A Company Name" & vbCrLf & "(888)765-4321"
End Sub

This will insert:

<blank line>
Joe Blow
A Company Name
(888)765-4321

You can add a button for the marco(s) to the Quick Access Toolbar in Outlook:

1. Open the item window for which you’d like to add the macro button to.
2. Click the little down arrow on the right side of the QAT and choose More Commands… or Click on the Office logo in the left top, choose Editor Options and select the Customize section.
3. In the drop down list “Choose commands from” select: Macros. (The list below will now show you all your macros.)
4. Select the macro that you wish to create a button for and press the Add >> button.
5. To modify the name and icon press the Modify… button.
6. Close the Editor Options dialog to return to your item window and use your button.