Solved

Boiler Text in Emails

Posted on 2014-01-28
4
257 Views
Last Modified: 2014-02-03
Hello Experts,

I reply to many emails throughout the day to customers, and I often find myself typing the same thing over and over again...

Is it possible to have some boiler text (I think that's what it is called), inserted into the email - when I either press a specific shortcut key, or maybe click on a specific button?

I use a program called, "Text Expander" on the Mac for my home computer, and I know there are other solutions for the PC.  But sadly, I am not allowed to install software on a work computer - so I need to figure out a round-about way of trying to accomplish the same thing.

Any ideas?

Thank you in advance for your help!
~ Geekamo
0
Comment
Question by:Geekamo
  • 3
4 Comments
 
LVL 31

Expert Comment

by:Frosty555
Comment Utility
You could probably do this with a Macro.

First, enable the Developer Tab
http://office.microsoft.com/en-ca/outlook-help/show-the-developer-tab-HA101819080.aspx

Then, go to compose a new message, go to the the Developer Tab, and go to "Macros". In the window that opens up, Type in a name for the macro (e.g. "MyNewMacro") and hit "Create".

Creating a new macro
This will open up the Visual Basic Editor. You will see a new subroutine automatically created.

Visual Basic Editor
Inbetween the "Sub" and "End Sub" lines is where you put the code for the Macro. In this case, insert the code below which will automate type some text into the current email message.


Application.ActiveInspector.WordEditor.Windows(1).Selection.TypeText Text:="Hello!"

Close the Visual Basic Editor.

Now, when you are composing a message, go to the Developer Tab, click on "Macros", it will now list all of the Macros you have created, and you can just go ahead and select "Project1.MyNewMacro", and it will spit out "Hello!" into your email message.

Running the Macro to type the text
You can repeat this for the various different boiler text you want to to be able to quickly type.
0
 
LVL 31

Expert Comment

by:Frosty555
Comment Utility
If you want to get really fancy, you can even create a new ribbon and embed the Macro directly into it.

Right click on a blank area of the Ribbon and select "Customize Ribbon". The dialog that pops up lets you customize the contents of the ribbon, and even add your own Tab, Groups, and Shortcuts into the ribbon in order to give you quick access to your favorite macros.

You want to select "Macros" from the dropdown on the left side, and then insert the macro into whatever part of the Ribbon you like - you can insert it into an existing tab/group, or create a new one.

Customizing the Ribbon
After you have finished customizing the ribbon, you can use it in the New Message window

Using the new Tab
0
 
LVL 31

Accepted Solution

by:
Frosty555 earned 500 total points
Comment Utility
Regarding the actual code for your Macro - it can get as complicated as you like. Reading up on how Visual Basic syntax works will help you out, but here's a few more complicated examples to get you started:

Enclose your text inside of doublequotes. If you need to actually use a doublequote, put two of them side by side.

Application.ActiveInspector.WordEditor.Windows(1).Selection.TypeText Text:="This is a ""bunch"" of text that will appear in the email"

Open in new window

This is a "bunch" of text that will appear in the email

Use the ampersand character to concatenate multiple strings of text together:

Application.ActiveInspector.WordEditor.Windows(1).Selection.TypeText Text:="This is a bunch of text" & "And here is some more"

Open in new window

This is a bunch of textAnd here is some more

Use the special expression vbCrLf to specify a line break. This does not go in doublequotes and must be an expression on it's own, which you may concatenate to the rest of the string using the ampersand character.

Application.ActiveInspector.WordEditor.Windows(1).Selection.TypeText Text:="This is a bunch of text" & vbCrLf & vbCrlf & "And this is on a new line"

Open in new window

This is a bunch of text

And this is on a new line
0
 
LVL 1

Author Closing Comment

by:Geekamo
Comment Utility
This has been working perfectly!  Thank you so much.  I love this!
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now