You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
All Posts
Outlook 2013
Outlook 2010
Outlook 2007
Outlook.com
Tips
How-to
News
Videos
Stories
The Living in Outlook series is about sharing tips and workflows around real-world scenarios. We’ll start the conversation with a topic – you can add to it by posting your tips and workflows in the comments!
In my last blog post I talked about how I use Message Templates and how to create them.
You may have noticed in my example template that I have special text to remind me to insert updated graphs and tables into my status reports. While I could continue to do this manually and risk forgetting to add them, I instead decided to save myself tons of time by using the “Paste as link” functionality in Outlook!
For this to work, I have an Excel file which I keep up-to-date with the latest data and graphs for each status report.
Here’s how to insert a link to those graphs so that the template is always up to date:
2. In Outlook, place the cursor where you want the graph to be, click on the lower half of the Past Button and choose Paste Special.
Thanks to the power of Outlook message templates and Paste Link, updating the information in your templates is easier than ever.
As always, let us know how you use this feature to make your Outlook experience even better!
Jed Brown Outlook Program Manager
Comments: (5) Collapse
Please could you tell me how I can change the colour of the archive folders or folder names in Outlook so that I stop transferring current emails into the Archive section by mistake when I should be storing them in the current Personal Folders. At the moment, they all look the same down the side of my screen and is confusing. Thank you for your help.
I'm a college sophomore, so my knowledge of Microsoft Office has been pretty much PowerPoints and Word .docs up until this point. I started playing around with Outlook a few days, and it's beyond me what I've been missing out on all along. I've already used message templates like the ones from your previous post, and depending on which one comes first, my knowledge for Excel or a need for a chart, I'll definitely use this one as well, :-). If you have any pointers on how to link OneNote and Outlook, that would be super.
I have set up a rule to reply with a template when I receive emails from a certain sender. The problem is the sender address is "name@domain.com on behalf of name@domain.com". What I want is for the reply to be sent to the on behalf address, and that works if I just reply manually to the email - the on behalf address is populated in the "To:" field. However, when the rule replies with the template, it sends to the actual sender's address, not the on behalf address. Is there anyway to have the on behalf address used in this situation??? I am pretty familiar with VB for Excel, but not for Outlook. Since there is an option in Rules and Alerts to run a script when a message comes in, I would think you could write one that 1) grabs the on behalf of address (using the SentOnBehalfofName property), 2) opens the reply template, 3) puts that address in the "To:" field, then sends. What do you think? If that sounds feasible, is that something you could give me some direction on? I have tried other message boards, and no one has been able to offer help on this, so I would REALLY appreciate it if you, or anyone who read this, can. Thanks,
Tim
tim.barr@live.com
Jed, I've tried this using Office Outlook 2007 / Excel 2007. The problem is that when I open the template it takes ages (and I mean ages) to update the linked charts. If I open the source workbook before opening the template, it ignores the fact it's already opened and appears to open it iteratively for each chart. Once it has done all this, I finally get the message prompt you describe. I do not get the same behaviour in Word 2007 - it recognises that the source workbook is open and th updates are almost immediate. FYI, I tried editing the links (ALT+F9) in the template and setting them to manual (removed the /a) but this behaviour still persists. Thanks,
Tim.
is there a similar technique I could use to attach the latest version of an (excel) file? the attachment will always be found in the same folder location with the same file name.
If not, how would you suggest I approach this? Thanks. Lee.
Comments: (loading) Collapse