Living in Outlook: Advanced Message Templates

re: Living in Outlook: Advanced Message Templates

Helen — Wed, 19 Nov 2008 15:37:48 GMT

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.

Microsoft Office interconnectivity

Sarah — Sun, 23 Nov 2008 23:44:02 GMT

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.

re: Living in Outlook: Advanced Message Templates

tsbarr — Sat, 06 Dec 2008 22:36:45 GMT

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

re: Living in Outlook: Advanced Message Templates

TimBurraston — Mon, 15 Dec 2008 20:06:48 GMT

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.

re: Living in Outlook: Advanced Message Templates

Lee Kennedy — Tue, 16 Dec 2008 21:32:26 GMT

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.