![]() |
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 everybody. I trie to make a macro that print my incoming email that
contains in subject word "Comanda online". This is the macro: Private Sub Application_NewMail() CheckMail End Sub Public Sub CheckMail() Dim OlApp As Outlook.Application Dim Inbox As Outlook.MAPIFolder Dim oOApp As Outlook.Application Dim oOMail As Outlook.MailItem Dim InboxItems As Outlook.Items Dim Mailobject As Object Dim Subject As String Set OlApp = CreateObject("Outlook.Application") Set Inbox = OlApp.GetNamespace("Mapi").GetDefaultFolder(olFold erInbox) Set InboxItems = Inbox.Items For Each Mailobject In InboxItems If Mailobject.UnRead Then Subject = Mailobject.Subject If Subject = "Comanda online" Then Mailobject.PrintOut End If Mailobject.UnRead = False End If Next Set OlApp = Nothing Set Inbox = Nothing Set InboxItems = Nothing Set Mailobject = Nothing End Sub It's working, but i want to print only the body of the email. Is this possible ? Thank you. Hope to reply to me. url:http://www.ureader.com/msg/1081942.aspx |
Ads |
#2
|
|||
|
|||
![]() I'd probably create a Word document, insert the body of the email, and then print the document instead of the email. -- Best regards Michael Bauer - MVP Outlook Manage and share your categories: http://www.vboffice.net/product.html?pub=6&lang=en Am Mon, 4 Jan 2010 12:52:58 +0800 schrieb Gardos Catalin: Hello everybody. I trie to make a macro that print my incoming email that contains in subject word "Comanda online". This is the macro: Private Sub Application_NewMail() CheckMail End Sub Public Sub CheckMail() Dim OlApp As Outlook.Application Dim Inbox As Outlook.MAPIFolder Dim oOApp As Outlook.Application Dim oOMail As Outlook.MailItem Dim InboxItems As Outlook.Items Dim Mailobject As Object Dim Subject As String Set OlApp = CreateObject("Outlook.Application") Set Inbox = OlApp.GetNamespace("Mapi").GetDefaultFolder(olFold erInbox) Set InboxItems = Inbox.Items For Each Mailobject In InboxItems If Mailobject.UnRead Then Subject = Mailobject.Subject If Subject = "Comanda online" Then Mailobject.PrintOut End If Mailobject.UnRead = False End If Next Set OlApp = Nothing Set Inbox = Nothing Set InboxItems = Nothing Set Mailobject = Nothing End Sub It's working, but i want to print only the body of the email. Is this possible ? Thank you. Hope to reply to me. url:http://www.ureader.com/msg/1081942.aspx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Running a Macro when email arrives | Sue Mosher [MVP][_3_] | Outlook and VBA | 0 | July 9th 09 02:17 PM |
Running a Macro when email arrives | Rob Girard | Outlook and VBA | 0 | July 9th 09 12:07 PM |
Running a Macro when email arrives | Irwin Quintana | Outlook and VBA | 0 | September 23rd 08 06:27 PM |
Outlook 2k: running vba when new mail arrives | Brian Schwartz | Outlook and VBA | 1 | November 13th 06 10:54 PM |
Outlook 2k: running vba when new mail arrives | Brian Schwartz | Outlook and VBA | 0 | November 13th 06 10:38 PM |