Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - General Queries (http://www.outlookbanter.com/outlook-general-queries/)
-   -   capitalizing appointments in Calendar in Outlook 2007 (http://www.outlookbanter.com/outlook-general-queries/100631-capitalizing-appointments-calendar-outlook-2007-a.html)

T March 3rd 10 02:47 PM

capitalizing appointments in Calendar in Outlook 2007
 
Date: Tue, 02 Mar 2010 14:04:22 -0800
From: "Leonid S. Knyshov // SBS Expert"
On 3/2/2010 1:26 PM, test wrote:
I have twenty different activities for each month which are present on the Outlook 2007 calendar. While entering the activities, I entered them in Sentence Case like "Meeting with Group A about Topic B". \\line\\line Now, is there a way I can capitalize the activites so that it looks like "MEETING WITH GROUP A ABOUT TOPIC B" in the Calendar without retyping it or copying and pasting the initial sentence(\\fs17 "Meeting with Group A about Topic B"\\fs17 ) to another application like Word 2007 where it can be capitalized easily using the inbuilt formatting of Word 2007 and then bringing it back to the Calendar?

Can someone please clarify?

Thanks


Can certainly be done with custom code. Can't be done with built-in
tools, to my knowledge.


Do you mean I need to use VBA by custom code?
Thanks

From: "Diane Poremsky [MVP]"


There is one utility that might do it within outlook or you could export to
excel and make the change there (using a VBA function) then import.
http://www.mapilab.com/outlook/toolbox/ can do search and replace, but I
don't know if it can change case.


Thanks for the utility link. A quick search reveals it does not
have the ability to change case.


Leonid S. Knyshov // SBS Expert March 3rd 10 06:43 PM

capitalizing appointments in Calendar in Outlook 2007
 
On 3/3/2010 6:47 AM, t wrote:
Date: Tue, 02 Mar 2010 14:04:22 -0800
From: "Leonid S. Knyshov // SBS oft.com
On 3/2/2010 1:26 PM, test wrote:
I have twenty different activities for each month which are present on the Outlook 2007 calendar. While entering the activities, I entered them in Sentence Case like "Meeting with Group A about Topic B". \\line\\line Now, is there a way I can capitalize the activites so that it looks like "MEETING WITH GROUP A ABOUT TOPIC B" in the Calendar without retyping it or copying and pasting the initial sentence(\\fs17 "Meeting with Group A about Topic B"\\fs17 ) to another application like Word 2007 where it can be capitalized easily using the inbuilt formatting of Word 2007 and then bringing it back to the Calendar?

Can someone please clarify?

Thanks


Can certainly be done with custom code. Can't be done with built-in
tools, to my knowledge.


Do you mean I need to use VBA by custom code?
Thanks

Either way. Whichever way is easier for you.

It's literally just a matter of looping through your calendar and
applying one function to each subject line. An Outlook coder can do this
very quickly. Post a project on odesk.com and let someone deal with it. :)

I would still hate to see things in all caps.
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you :)


All times are GMT +1. The time now is 06:10 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com