Need to automate the editing of the subject of daily calendar events.

[ajaeger]

I have a product that pulls in the daily weather forcast and places it in Outlook as an all day event. The subject of this event reads "Alexandria - Monday: Intermittent Clouds; Hi 77 F ; Lo 56" It's too long. I want to edit the Subject so that it only prints everything to the right of the colon. Is there a way to do this with a keystroke macro (ie, putting the cursor at the left side of the field and holding Ctrl+Shift, then hitting the right arrow 4 times, then hitting the Delete key, then Save.)

I'd want this macro to run against all future weather forcast Calendar Events (they are pulled into Outlook 5 days out from the current date).

Thanks.

Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com

 

[zelgar]

Here's some normal code that will do what you want:

=RIGHT(A1,LEN(A1)-FIND(":",A1))

If you want a macro, ask in VBA Visual Basic for Applications (Microsoft) forum

http://tek-tips.com/threadminder.cfm?pid=707