Solved

Set default subject in Outlook 2010

Posted on 2011-09-14
3
1,019 Views
Last Modified: 2012-08-13
Hi,

I would like to set a default subject in Outlook 2010, so every time I open an email the subject has the same details.

As a work around, I have worked out that by using the mailto: command and using ?subject this will open a new email with the relevant subject, but I can't understand how to create add this as a hyperlink to the toolbar, as there is no option like in 2003?

Any help is appreciated.
0
Comment
Question by:pcsouthwest
3 Comments
 
LVL 1

Accepted Solution

by:
GJohn32 earned 250 total points
ID: 36537905
Creating a template is one way.

Create the email and save it as a template(.oft).
Then on the  Quick Access Toolbar(top left) click on the drop down.
Click on More Commands
Change the 'Choose Commands From' field to All Commands.
Select the 'Choose Form' command and add to the Quick Access Toolbar
Click Okay
Now click on the 'Choose Form' icon
Look in field, change to User Templates in File System
Select your template and click Open.
0
 
LVL 12

Assisted Solution

by:viralypatel
viralypatel earned 250 total points
ID: 36537919
use this macro:

Sub Emerging_Mail_Sheet_Outlook_Body()
Sheets("Emerging").Select
' Don't forget to copy the function RangetoHTML in the module.
' Working in Office 2000-2007
Dim rng As Range
Dim OutApp As Object
Dim OutMail As Object
Today= Format(Now(), "mm-dd-yy")
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
Set rng = Nothing
Set rng = ActiveSheet.UsedRange
'You can also use a sheet name
'Set rng = Sheets("YourSheet").UsedRange
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.To = "Test"
.CC = ""
.BCC = ""
.Subject = "Daily Issues - " & Today
.HTMLBody = RangetoHTML(rng)
.Display 'or use .Send
End With
On Error GoTo 0
With Application
.EnableEvents = True
.ScreenUpdating = True
End With
Set OutMail = Nothing
Set OutApp = Nothing
End Sub

Open in new window


Source: http://www.mrexcel.com/forum/showthread.php?t=342096
0
 

Author Closing Comment

by:pcsouthwest
ID: 37043883
Thank you, both ways look viable to answer the issue. In the end I created an shortcut on the desktop as   mailto:?subject=hello   . This opens an blank email with the subject "Hello". V simple and now I have others with other subjects, ie have you tried powering off and on a again?

Thank you.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Learn more about how the humble email signature can be used as more than just an electronic business card. When used correctly, a signature can easily be tailored for different purposes by different departments within an organization.
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

896 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

18 Experts available now in Live!

Get 1:1 Help Now