Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Managing messages before sending (http://www.outlookbanter.com/outlook-vba/72595-managing-messages-before-sending.html)

Markus May 26th 08 04:58 PM

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

Sue Mosher [MVP-Outlook] May 26th 08 05:04 PM

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


Markus May 28th 08 04:23 AM

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



Sue Mosher [MVP-Outlook] May 28th 08 04:42 AM

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



Shri August 20th 08 09:31 PM

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