How to count characters in OL 2007 message

[jerryk]

I send text messages that need to be under a certain number of characters. I
would like Outlook 2007 to tell me the number of characters in the email I am
composing. I have done it in Outlook 2003 with Word 2003 as the edittor
using Word's word count feature. But, I don't see how to do this in 2007.

Thank you.
JerryK

 

[Michael Bauer [MVP - Outlook]]

This few lines of VBA code might be an option:

Public Sub CountMyStuff()
MsgBox Len(Application.ActiveInspector.Currentitem.Body)
End Sub

You may add a button to the toolbar of your mail window and call the macro
from there.

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 1 Oct 2008 09:04:01 -0700 schrieb jerryk:

 

[jerryk]

Works great! Thank you.
JerryK

This few lines of VBA code might be an option:

Public Sub CountMyStuff()
MsgBox Len(Application.ActiveInspector.Currentitem.Body)
End Sub

You may add a button to the toolbar of your mail window and call the macro
from there.

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 1 Oct 2008 09:04:01 -0700 schrieb jerryk:

 

[Terry Hansen]

I need to count characters in OL 2007 also but cannot figure out how to add the VBA code to OL 2007 and create a button for the menue. Can you elaborate on this please.

I send text messages that need to be under a certain number of characters. I
would like Outlook 2007 to tell me the number of characters in the email I am
composing. I have done it in Outlook 2003 with Word 2003 as the edittor
using Word's word count feature. But, I don't see how to do this in 2007.

Thank you.
JerryK

Public Sub CountMyStuff()
MsgBox Len(Application.ActiveInspector.Currentitem.Body)
End Sub

You may add a button to the toolbar of your mail window and call the macro
from there.

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 1 Oct 2008 09:04:01 -0700 schrieb jerryk:

I
am

On Wednesday, October 22, 2008 5:28 PM jerry wrote:
Works great! Thank you.
JerryK

"Michael Bauer [MVP - Outlook]" wrote:

Submitted via EggHeadCafe - Software Developer Portal of Choice
Book Review: Excel 2010 - The Missing Manual [OReilly]
http://www.eggheadcafe.com/tutorial...w-excel-2010--the-missing-manual-oreilly.aspx

 

[Gordon]

I need to count characters in OL 2007 also but cannot figure out how to add the VBA code to OL 2007 and create a button for the menue. Can you elaborate on this please.

The Word Count details includes a Character count....in the New Message
window click on the drop-down arrow under Spelling..


And you REALLY think anyone is monitoring a thread nearly TWO years old?

 

[BlueQuail]

No one may be monitoring this thread after another year but, Gordon, thanks for your instructions. Just started to use SMS in Outlook 2007 and this is just what I was looking for.