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

Automate to send few information



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 1st 07, 05:34 AM posted to microsoft.public.outlook.program_vba
mrbalaje
external usenet poster
 
Posts: 14
Default Automate to send few information

Hello,

Daily I am receiving a mail with the same subject. The email will only
consist of 3 lines text. The first two lines are always the same. The third
line will be different with the data on the particular day.

I want to send the info which is in the third line along with the standard
text which I compose daily to an another receipient.

I want to automate this process, whenever I get the mail, the outlook should
automatically compose the message for me and send to the receipient which I
mentioned. Any coding for this please.


Ads
  #2  
Old January 2nd 07, 07:17 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Automate to send few information



You can create a Run-a-Script-Rule that recognizes the e-mail by its subject
and calls a script. That one might look like this:

Public ScriptName(Mail As Outlook.MailItem)
Dim ar() as String
ar=Split(Mail.Body,vbcrlf)
End Sub

Now the Array ar contains each line in one Array item. Maybe ar(2) is what
you call the third line, maybe it's not. That depends on how many line
breaks are in the e-mail's body.

Once, you have that line you can create a new e-mail with the CreateItem
function or call Forward to forward the item. Write e.g. ar(2) into the
mail's Body property, add the recipients's address via Recipients.Add and
call Send.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Keep your Outlook categories organized!
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)

Am Sun, 31 Dec 2006 20:34:00 -0800 schrieb mrbalaje:

Hello,

Daily I am receiving a mail with the same subject. The email will only
consist of 3 lines text. The first two lines are always the same. The

third
line will be different with the data on the particular day.

I want to send the info which is in the third line along with the standard
text which I compose daily to an another receipient.

I want to automate this process, whenever I get the mail, the outlook

should
automatically compose the message for me and send to the receipient which

I
mentioned. Any coding for this please.

 




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
Automate email send to multiple people with different attachments [email protected] Outlook and VBA 2 June 30th 06 04:57 PM
How Do I automate contat name on calendar NewsSearch Outlook - Calandaring 3 April 20th 06 01:41 PM
Can I automate creating new folders? Chris Outlook and VBA 1 April 5th 06 06:39 AM
Is it possible to automate this? John 3:16 Outlook - General Queries 0 March 27th 06 03:26 PM
Automate keystrokes w/ VBA? Rich Roller Outlook and VBA 10 February 23rd 06 04:53 PM


All times are GMT +1. The time now is 09: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-2025 Outlook Banter.
The comments are property of their posters.