Solved

Set default subject in Outlook 2010

Posted on 2011-09-14
3
1,014 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Get an idea of what you should include in an email disclaimer with these Top 5 email disclaimer tips.
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
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 …
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

757 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

20 Experts available now in Live!

Get 1:1 Help Now