![]() |
Managing messages before sending
I have had to develop an email system without the use of Outlook, but would
like to see if I can integrate the same functionality using Outlook to take advantage of the extensive OL email features. My need is to be able to capture outgoing email before it is sent in order to merge data from a table, and in order to save the final version of the email message into a table. The saved version must include any edits done by the user before they clicked on send in OL. As near as I can tell, this is not possible cause once you run OL from another app, OL takes over and if user clicks on Send in their OL editor (e.g., Word) the edited message goes out. That is, when the user clicks on Send and before the message goes out, I would like to replace certain strings that I identify as table fields with info from the table, and would like to save that final msg version to a table. Anyone have any ideas on how I might do this, or even if it would be possible? Thanks in advance for any suggestions, Mark |
Managing messages before sending
You can use the Application.ItemSend event from the Outlook object model to work with the message after the user clicks Send.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Markus" wrote in message ... I have had to develop an email system without the use of Outlook, but would like to see if I can integrate the same functionality using Outlook to take advantage of the extensive OL email features. My need is to be able to capture outgoing email before it is sent in order to merge data from a table, and in order to save the final version of the email message into a table. The saved version must include any edits done by the user before they clicked on send in OL. As near as I can tell, this is not possible cause once you run OL from another app, OL takes over and if user clicks on Send in their OL editor (e.g., Word) the edited message goes out. That is, when the user clicks on Send and before the message goes out, I would like to replace certain strings that I identify as table fields with info from the table, and would like to save that final msg version to a table. Anyone have any ideas on how I might do this, or even if it would be possible? Thanks in advance for any suggestions, Mark |
Managing messages before sending
Sue,
Don't suppose you know of some vba code out there that may use Itemsend. An example would help me get started. Thanks, Mark "Sue Mosher [MVP-Outlook]" wrote: You can use the Application.ItemSend event from the Outlook object model to work with the message after the user clicks Send. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Markus" wrote in message ... I have had to develop an email system without the use of Outlook, but would like to see if I can integrate the same functionality using Outlook to take advantage of the extensive OL email features. My need is to be able to capture outgoing email before it is sent in order to merge data from a table, and in order to save the final version of the email message into a table. The saved version must include any edits done by the user before they clicked on send in OL. As near as I can tell, this is not possible cause once you run OL from another app, OL takes over and if user clicks on Send in their OL editor (e.g., Word) the edited message goes out. That is, when the user clicks on Send and before the message goes out, I would like to replace certain strings that I identify as table fields with info from the table, and would like to save that final msg version to a table. Anyone have any ideas on how I might do this, or even if it would be possible? Thanks in advance for any suggestions, Mark |
Managing messages before sending
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
MsgBox Item.Subject End Sub As with any event, a good place to start is the topic in Help. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Markus" wrote in message ... Sue, Don't suppose you know of some vba code out there that may use Itemsend. An example would help me get started. Thanks, Mark "Sue Mosher [MVP-Outlook]" wrote: You can use the Application.ItemSend event from the Outlook object model to work with the message after the user clicks Send. "Markus" wrote in message ... I have had to develop an email system without the use of Outlook, but would like to see if I can integrate the same functionality using Outlook to take advantage of the extensive OL email features. My need is to be able to capture outgoing email before it is sent in order to merge data from a table, and in order to save the final version of the email message into a table. The saved version must include any edits done by the user before they clicked on send in OL. As near as I can tell, this is not possible cause once you run OL from another app, OL takes over and if user clicks on Send in their OL editor (e.g., Word) the edited message goes out. That is, when the user clicks on Send and before the message goes out, I would like to replace certain strings that I identify as table fields with info from the table, and would like to save that final msg version to a table. Anyone have any ideas on how I might do this, or even if it would be possible? Thanks in advance for any suggestions, Mark |
Managing messages before sending
Hello,
I am trying to capture every mail item when I click on the "send" button and append a disclaimer based on the receipient to the mailitem using VBA. In this regard, I tried to implement your code below but the code is never initiated. What am I doing wrong? Thanks, Srikanth "Sue Mosher [MVP-Outlook]" wrote: Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) MsgBox Item.Subject End Sub As with any event, a good place to start is the topic in Help. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Markus" wrote in message ... Sue, Don't suppose you know of some vba code out there that may use Itemsend. An example would help me get started. Thanks, Mark "Sue Mosher [MVP-Outlook]" wrote: You can use the Application.ItemSend event from the Outlook object model to work with the message after the user clicks Send. "Markus" wrote in message ... I have had to develop an email system without the use of Outlook, but would like to see if I can integrate the same functionality using Outlook to take advantage of the extensive OL email features. My need is to be able to capture outgoing email before it is sent in order to merge data from a table, and in order to save the final version of the email message into a table. The saved version must include any edits done by the user before they clicked on send in OL. As near as I can tell, this is not possible cause once you run OL from another app, OL takes over and if user clicks on Send in their OL editor (e.g., Word) the edited message goes out. That is, when the user clicks on Send and before the message goes out, I would like to replace certain strings that I identify as table fields with info from the table, and would like to save that final msg version to a table. Anyone have any ideas on how I might do this, or even if it would be possible? Thanks in advance for any suggestions, Mark |
All times are GMT +1. The time now is 06:12 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-2006 OutlookBanter.com