How to count characters in OL 2007 message

  • Thread starter Thread starter jerryk
  • Start date Start date
J

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
 
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:
 
Works great! Thank you.
JerryK

Michael Bauer said:
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:
Click to expand...
 
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
Click to expand...
On Wednesday, October 22, 2008 5:28 PM jerry wrote:
Works great! Thank you.
JerryK

"Michael Bauer [MVP - Outlook]" wrote:
Click to expand...
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
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.
Click to expand...

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?
 
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.
 
Back
Top