A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Need Help for fire department



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old October 30th 08, 01:30 AM posted to microsoft.public.outlook.program_vba
Matt Melton
external usenet poster
 
Posts: 2
Default Need Help for fire department

OK our County Dispatch sends out emails/text messages with our current calls
for our fire department, however 3/4 of our Fire Department has sprint
phones and we only receive the first 160 characters. I need a little help
writing a macro for outlook that automatically forwards an email when
received through a specified account that only selects the first 160
characters and forwards it as the first message and then selects the rest of
the message and forwards it as the second message... Anyone got any ideas?
its been waaay to long since my coding classes... Does this make any sense
to anyone?

url:http://www.ureader.com/gp/1081-1.aspx
  #2  
Old November 2nd 08, 05:33 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Need Help for fire department



What Outlook version?

--
Best regards
Michael Bauer - MVP Outlook

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


Am Thu, 30 Oct 2008 09:30:49 +0800 schrieb Matt Melton:

OK our County Dispatch sends out emails/text messages with our current

calls
for our fire department, however 3/4 of our Fire Department has sprint
phones and we only receive the first 160 characters. I need a little help
writing a macro for outlook that automatically forwards an email when
received through a specified account that only selects the first 160
characters and forwards it as the first message and then selects the rest

of
the message and forwards it as the second message... Anyone got any ideas?
its been waaay to long since my coding classes... Does this make any sense
to anyone?

url:http://www.ureader.com/gp/1081-1.aspx

  #3  
Old November 8th 08, 12:00 AM posted to microsoft.public.outlook.program_vba
Matt Melton
external usenet poster
 
Posts: 2
Default Need Help for fire department

either outlok 2007 or the version right before

url:http://www.ureader.com/msg/10814096.aspx
  #4  
Old November 8th 08, 07:47 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Need Help for fire department



With the Outlook object model you can't read by which account an e-mail has
been received. You could do that with Redemption (www.dimastr.com) for
instance.

Another workaround would be to create a rule to run a script. The condition
for that rule would be 'through specified account'.

That script could be something like this; you just have to add the
recipients:

Public Sub Example(Mail as Outlook.MailItem)
Dim Fw as Outlook.MailItem
Dim Length&
Dim Done&
Dim Msg$

Length=Len(Mail.Body)
While DoneLength
Msg=Mid$(Mail.Body, Done+1, 160)
Set Fw=Mail.Forward
' Set Recipients
Fw.Body=Msg
Fw.Send
Done=Done+160
Wend
End Sub

--
Best regards
Michael Bauer - MVP Outlook

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


Am Sat, 8 Nov 2008 08:00:32 +0800 schrieb Matt Melton:

either outlok 2007 or the version right before

url:http://www.ureader.com/msg/10814096.aspx

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add Name, Phone, Department into footnote? Eric Outlook Express 2 May 19th 08 09:15 AM
Department Calendars [email protected] Outlook - Calandaring 1 March 23rd 07 12:30 PM
corp/department calendar questions Villain Outlook - Calandaring 1 December 2nd 06 03:09 PM
Recepient properties (such as department) waxwing Outlook and VBA 3 August 10th 06 02:55 PM
Create a shared calendar for a department Cheri Outlook - Calandaring 7 June 2nd 06 11:52 PM


All times are GMT +1. The time now is 12:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.