Managing messages before sending

[Markus]

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]]

You can use the Application.ItemSend event from the Outlook object model to work with the message after the user clicks Send.

 

[Markus]

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]]

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