![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
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 |